Vlookup qustion.

[DebtAcquisitions]

Hi, I need a little help and I hope I can explain this correctly.

I have a document with multiple sheets. (sheet1, sheet2, sheet3). There are hundreds of thousands of business names in one column on the first sheet. we will say (sheet1!A)

I need to compare the name of the business to the columns in sheet2 and return the number that resides one cell to the right.

the problem is that column 1 is one group of business names and numbers and on column 4 is a different group of names and numbers. the business names do not exist in both groups (as far as I can tell) and I cannot combine these columns into one.

I need to be able to search the first column for the business name and return the number, if the name is NOT in that list I need it to check the second group (column 4) of names (and so on).....

I was thinking about an if statement but I am not having luck with this.

any ideas on how to do this?

 

[DebtAcquisitions]

forgot to attach this.

this is basically what I was trying to do: =if(VALUE(VLOOKUP(sheet1!A:B,2,0)=0,VLOOKUP(sheet2!D:E,2,0)))

 

[Superstar31]

forgot to attach this.

this is basically what I was trying to do: =if(VALUE(VLOOKUP(sheet1!A:B,2,0)=0,VLOOKUP(sheet2!D:E,2,0)))

have you tried iferror? and why can't you concatenate?

finally can you upload a copy of your file or an example somewhere..

 

[DebtAcquisitions]

Iferror did exactly what I was looking for, Thanks!

=IFERROR(VLOOKUP(Q5,Lender_DebtType!A:B,2,0),VLOOKUP(Q5,Lender_DebtType!D:E,2,0))