Vlookup with multiple workbooks
 

Is there a way to do a VLOOKUP when there are more than 2 workbooks in Excel
? and how?

When I try using this formula I get an error that says "#VALUE!".

=VLOOKUP("Net Income", EXAMPLE!A4:F9+'EXAMPLE1'!A1:FG,3,FALSE)

So basically I just want to find the corresponding amount in column 3 for
Net Income from the workbooks "Example" and "Example1". It doesn't work.

However, if I for example wanted to do the VLOOKUP on 1 workbook only it
works. What am I doing incorrectly or is it just not possible to do for more
than 1 workbook?

Thank you for your assistance.

Vlookup with multiple workbooks
 

You can't do it. (Just as you can't have the VLOOKUP reference multiple
selections in the same sheet, you can't reference multiple workbooks).

But perhaps:
=IF(ISERROR(VLOOKUP("Net Income", EXAMPLE!A4:F9,3,FALSE)),VLOOKUP("Net
Income",'EXAMPLE1'!A1:FG,3,FALSE),VLOOKUP("Net Income",
EXAMPLE!A4:F9,3,FALSE))

will accomplish your goal.

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Sally" wrote:

Is there a way to do a VLOOKUP when there are more than 2 workbooks in Excel
? and how?

When I try using this formula I get an error that says "#VALUE!".

=VLOOKUP("Net Income", EXAMPLE!A4:F9+'EXAMPLE1'!A1:FG,3,FALSE)

So basically I just want to find the corresponding amount in column 3 for
Net Income from the workbooks "Example" and "Example1". It doesn't work.

However, if I for example wanted to do the VLOOKUP on 1 workbook only it
works. What am I doing incorrectly or is it just not possible to do for more
than 1 workbook?

Thank you for your assistance.