Forum Discussion
VLOOKUP
The formula VLOOKUP consists on this: =VLOOKUP(lookup value, range containing the lookup value, the column number in the range containing the return value, Approximate match (TRUE) or Exact match ...
Hi Miguel_Zafiro,
If you want vlookup to search through 3 different table I'd use something like this...
=ifna(vlookup(value,table1,column index),ifna(vlookup(value,table2,column index), vlookup(value,table3,column index)))
See attached screenshot for example.
