Forum Discussion

Copper Contributor

Nov 16, 2017

Solved

Formula Help for Vlookup and IF

I have a worksheet with three tabs. Tab A is my working tab. I need to perform a VLOOKUP to find data in a cell on Tab B. If there is no match on Tab B, I need to produce the value from Tab C. I ...

Formulas & Functions

Need Help

SergeiBaklan
Nov 16, 2017
Hi Kim,

You shall check on error, like
=IF(ISNA(VLOOKUP on TabB), VLOOKUP on TabC, VLOOKUP on TabB)

SergeiBaklan

Diamond Contributor

Nov 16, 2017

Hi Kim,

You shall check on error, like

=IF(ISNA(VLOOKUP on TabB), VLOOKUP on TabC, VLOOKUP on TabB)

Kim Robin Hicks

Copper Contributor

Nov 16, 2017

Thank you! That worked perfectly.