Please Help! If statement combined with vlookup.

[bkoeni3]

I am trying to create a vlookup off of two different spreadsheets. If the source is not on one spreadsheet, it is on the other sheet. I think I should be using some type of ISNA or ISERROR Formula, but nothing I try works. Here is what I need to happen.

1. I want to do a vlookup off spreadsheet #1.

2. If the information is not available on spreadsheet one (meaning the formula should return an #N#A, I want to do a vlookup off of spreadsheet #2.

Can anyone provide me with the formula that would allow me to do this? Thanks in advance!

 

[Lewiy]

Try something like this:

=IF(ISNA(VLOOKUP(value,sheet1!range,column,type)),VLOOKUP(value,sheet2!range,column,type),VLOOKUP(value,sheet1!range,column,type))

Or you could also use COUNTIF as the orginal test to see if the value is in sheet1 to make the formula slightly shorter.