CODEWITHSUNDEEP
excelformula
Johan Coetzer
Johan Coetzer

Reputation: 1

Excel: How to lookup different values with the same criteria

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")

Upvotes: 0

Views: 47

Answers (1)

cybernetic.nomad
cybernetic.nomad

Reputation: 6418

Try the following formula:

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

An example:

enter image description here

Upvotes: 2

Related Questions