-1

Greetings

I need a formula for the below table to look up 2 values if it matches I should get the desired information. I tried the following formula but not working =VLOOKUP(D2 & C5,A2:D5,2,FALSE)

result sohlud be = 300

for example

looking values are USER & OID if matched, should give the AMOUNT value

enter image description here

user19328544
  • 35
  • 4
  • Instead of `VLOOKUP()` try using `INDEX()` & `MATCH()` with a delimiter in between for the lookup value or use `XLOOKUP()`. – Mayukh Bhattacharya Jul 11 '23 at 12:24
  • Why don't you share the rest of the information (a screenshot or an explanation)? I mean, you have to read the values from somewhere to look them up in this table and return the result (somewhere). You should use structured references to reap the benefits of the data being in an Excel table. – VBasic2008 Jul 11 '23 at 13:10

1 Answers1

1

You could use FILTER: filter instead:

=FILTER(B2:B5,(C2:C5=C5)*(D2:D5=D2))

Result:

enter image description here

user11222393
  • 3,245
  • 3
  • 13
  • 23