Excel: How to lookup different values with the same criteria [duplicate]

Question

Ex:

Sheet1 - Kollekte Ontvang

Column 1             Column 2     Column 3
Date             ProjectCodes         Amount


01/11/2024        G172                 1000
01/12/2024        G172                 1100
01/010/2025       G172                 1150

Sheet2 (want the values to show here)

column 1   Column2  Column3  Column4
G172       1000      1100     1150

Which formula do I use

Thank you for the help

used

=IFERROR(XLOOKUP(L$2&$C3,'KOLLEKTE ONTVANG'!$E:$E&'KOLLEKTE ONTVANG'!$H:$H,'KOLLEKTE ONTVANG'!$S:$S),0)

and

=SUMIFS('KOLLEKTE ONTVANG'!$S:$S,'KOLLEKTE ONTVANG'!$E:$E,S$2,'KOLLEKTE ONTVANG'!$H:$H,Opsomming!$C3,'KOLLEKTE ONTVANG'!$A:$A,">=01/10/2024",'KOLLEKTE ONTVANG'!$A:$A,"<=28/02/2025")

This already has a solution and has been posted multiple times, please make an attempt to research the forum first! — Mayukh Bhattacharya
– Mayukh Bhattacharya, Commented Feb 11 at 14:48

cybernetic.nomad · Accepted Answer · 2025-02-11 13:54:58Z

2

Try the following formula:

=TRANSPOSE(FILTER(C$2:C$7,B$2:B$7=F2))

An example:

answered Feb 11 at 13:54

cybernetic.nomad

6,5663 gold badges20 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dominique Feb 11 at 14:00

I was about to write the same thing, using =ToRow() instead of =Transpose() (yours is better 😀).

Collectives™ on Stack Overflow

Excel: How to lookup different values with the same criteria [duplicate]

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related