CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
JPashs
JPashs

Reputation: 13896

GOOGLE sheets: search pair of values in two column to match and get value

I a GOOGLE sheets, I need to search for a pair of values in two column to match and get value.

Take a look at this capture to see what I mean:

enter image description here

I tried with =VLOOKUP(B2:C2;F:G;E:E) in this google sheets document (anyone can edit): https://docs.google.com/spreadsheets/d/1D2VPUvxJIZxIY1cqbgsoDnja2g1pmw19ScNA1JLQ1mg/edit?usp=sharing but it not working.

Is there a way to do this.

Upvotes: 3

Views: 1975

Answers (1)

JPV
JPV

Reputation: 27292

In A2 try

=ArrayFormula(IF(LEN(B2:B)*LEN(C2:C); VLOOKUP(B2:B&C2:C; {F2:F&G2:G\ E2:E}; 2; 0);))

enter image description here

Upvotes: 4

Related Questions