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

0
votes

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.

1
google-sheetsgoogle-sheets-formula

1 Answers

2
votes

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