vlookup more than 2 range

[hitesh]

dear

i have a database of three sheets, and i want the vlookup in sheet 4, when i
use this formula =IF(ISNA(VLOOKUP($C3,'sheet
8'!$A$2:$F$58,2,FALSE)),VLOOKUP($C3,'sheet
9'!$A$2:$F$50,2,FALSE),VLOOKUP($C3,'sheet 8'!$A$2:$F$58,2,FALSE)), it work
only for 2 sheets. i want that 3rd sheet also covered by this formula, what i
have to do pls make the necessary changes in formula.

regards
anil

 

[Ken]

Your formula as written is only looking @ WorkSheets 8 & 9

 

[hitesh]

dear,
thanks for formula, but its not working, i type the formula this way its not
working
=IF(ISNA(VLOOKUP(C3,INDIRECT("'"&INDEX(Sheet2!,MATCH(1,--(COUNTIF(INDIRECT("'"&Sheet3!&"'!A2:F58"),C3)>0),0))&"'!A2:F58"),2,0)),"",VLOOKUP(C3,INDIRECT("'"&INDEX(Sheet4!,MATCH(1,--(COUNTIF(INDIRECT("'"&Sheet5!&"'!A2:F58"),C3)>0),0))&"'!A2:F58"),2,0))

pls make the changes.