View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
hitesh hitesh is offline
external usenet poster
 
Posts: 70
Default vlookup more than 2 range

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