Vlookup Based On 2 Columns - Google Sheets

1
votes

I'm consolidating two sheets that are populated via two separate google forms. I'm trying to find a row where 2 column items match to return a different cell via vlookup.

Example: I need to get value in 'NAMES SHEET'!C4 to appear in 'SHOPS SHEET'!C3.

I'm trying to match both the DATE and SHOP columns - but have had no luck.

I've tried using 'NAMES SHEET'!A4&'NAMES SHEET'!B4 as my search parameters, but it concats the two cells together. I've been stuck at this a while- any suggestions would be greatly appreciated!

enter image description here enter image description here

2
google-sheetsconcatenationgoogle-sheets-formulaarray-formulasgs-vlookup

2 Answers

1
votes

use in 'SHOPS SHEET'!C3:

=ARRAYFORMULA(IFNA(VLOOKUP(A3:A&B3:B, 
 {'NAMES SHEET'!A3:A&'NAMES SHEET'!B3:B, 'NAMES SHEET'!C3:C}, 2, 0)))
0
votes

You can use FILTER in 'SHOPS SHEET'!C3:

=IFNA(FILTER('NAMES SHEET'!C3:C, 'NAMES SHEET'!A3:A = A3:A, 'NAMES SHEET'!B3:B = B3:B))

Not you case probably, but if there are data like this in NAMES SHEET there will be a problem with VLOOKUP using concatenated columns:

enter image description here