I am trying to return a value with 3 lookups from vlookup.
This is what I tried
Data table![]()
=VLOOKUP(O2&P2&Q2,data,4,0)
60060127 2589315470 76.65 11 60060127 2589315470 33.53 12
Trying to match 60060127, 2589315470, 76.65 and return 11. When I use the formula above, I get #N/A
Any ideas??
Bookmarks