Vlookup in different sheets or workbooks

[shmemushi]

hi,
for the moment i am using

=VLOOKUP(a2, sheet1!A1:b10, 2, TRUE)

if you see that i am using it only for one sheet, that is sheet1. is there any one that can help me to use this formula for "sheet2" as well. so to lookup at both sheets.

many thanks in advance

[darkyam]

You can use =IF(Iserror(Vlookup(A2,Sheet1!A1:B10,2,0)),Vlookup(A2,Sheet2!A1:B10,2,0),Vlookup(A2,Sheet1!A1:B10,2,0). The True has to be changed to False (or 0, which I prefer using) because otherwise, it will return the closest match without going over, meaning it is unlikely to find an error.

[shmemushi]

thanks darkyam

your formula works perfect for 2 sheets, i was trying to make it available for 3rd, 4rth and so on sheets but couldn't make it. any other option?
many thanks

[Fotis1991]

Hi

If you post a sample workbook, i think i can saw you the way to do this.

Regards.