Formula Help for Vlookup and IF

[Kim Robin Hicks]

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 also need to multiple any cell amount by 1000.

I wrote:

=IF(((VLOOKUP(A71,TabB,8,FALSE)*1000)>0),((VLOOKUP(A71,TabB,8,FALSE)*1000)),((VLOOKUP(A72,TabC,10,FALSE)*1000)))

I know I could use "" but I chose not to.

I get the correct value if there is a match in Tab B, but if there is not a match, I just get N/A.  It's not looking at Tab C at all.

Thanks for your help.

[#2 · Accepted solution]

Hi Kim,

You shall check on error, like

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

[#3]

Thank you!  That worked perfectly.