VLOOKUP in Microsoft Excel - Microsoft Community

how use 2 lookup values in vlookup function? have 2 different values need use i've created function uses 1 of 2 values not both.

hi,

do mean if first value not found, try second value?

you iferror

=iferror(vlookup(.....),iferror(vlookup(....),""))

Office / Excel / Mac / Office 2016 for Mac