Vlookup

[KT]

How do I look up something and combine data from three individual workbook or
excel file?
like sheet1, sheet2, and sheet3
I know the standard vlookup formula =vlookup(A1,data$a$1:$C$6500,2,false),
but this only combine two spreadsheet. I my case I need to do combine three
or more worksheets or files.
Thanks your assistance in advance

 

[StumpedAgain]

the easiest way is to do a "=IF(ISNA(VLOOKUP(etc.)) that is nested. That
way, if it doesn't find it in the first sheet, it can look to the second and
then to the third. Here's an example I used the other day:

=IF(ISNA(VLOOKUP($A35,'RFL-Early'!$C$6:$I$52,I$9,FALSE)),IF(ISNA(VLOOKUP($A35,'FRP-Early'!$C$4:$I$45,I$9,FALSE)),VLOOKUP($A35,'RRP-Early'!$C$5:$J$73,I$9,FALSE),VLOOKUP($A35,'RRD-Early'!$C$4:$I$45,I$9,FALSE)),VLOOKUP($A35,'PRL-Early'!$C$6:$I$52,I$9,FALSE))

 

[st]

the easiest way is to do a "=IF(ISNA(VLOOKUP(etc.)) that is nested.  That
way, if it doesn't find it in the first sheet, it can look to the second and
then to the third.  Here's an example I used the other day:

=IF(ISNA(VLOOKUP($A35,'RFL-Early'!$C$6:$I$52,I$9,FALSE)),IF(ISNA(VLOOKUP($A­35,'FRP-Early'!$C$4:$I$45,I$9,FALSE)),VLOOKUP($A35,'RRP-Early'!$C$5:$J$73,I­$9,FALSE),VLOOKUP($A35,'RRD-Early'!$C$4:$I$45,I$9,FALSE)),VLOOKUP($A35,'PRL­-Early'!$C$6:$I$52,I$9,FALSE))

--
-SA





- Show quoted text -

You could do 2 separate colums with normal vlookups (col b, col c),
each w/ a look-up to a different sheet. Then in a 3rd column, do
=if(iserror(b1),c1,b1). This would say if your vlookup in column B is
an error, use the vlookup in column C, otherwise use column B.