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

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))

--
-SA


"KT" wrote:

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

On Jul 15, 1:56*pm, StumpedAgain
wrote:
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*3 5,'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



"KT" wrote:
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- Hide quoted text -

- 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.