# VLOOKUP() Using Multiple Sheets?

• Quick question:

When using VLOOKUP, is it possible use the reference value (parameter one) from one sheet, and then use an array to look in in a diffrent sheet? Or is this function only applicable to one sheet? I can't get it to work in multiple sheets, but was just curious. Is this an advantage of using INDEX(MATCH(), MATCH()) [which I'm using]?

Thanks for any input!

Bubbis Thedog

:silverha:

• Re: VLOOKUP() Using Multiple Sheets?

to the best of my knowledge, lookups should work with even different workbooks.

"Doubt everything. Find your own light." -- Gautama Buddha

• Re: VLOOKUP() Using Multiple Sheets?

Thanks for the response, milyenabox.

Let's say we have two worksheets: WS1 and WS2. In a cell in WS2, I input the formula

=VLOOKUP(A1,'WS1'!A1:F118,6)

A1 will always match a value in column A of WS1.

I'd think this formula would return the value in column F of WS1 whose column A value (the eventual row reference) matches the value of A1 in WS2. It does return a value from WS1, and from column F; but the value is from a different row than I'd expect. That is, the value that is used for a row reference in WS1 is not the same as A1. All of my column A values are unique, by the way. Any ideas on what may be causing this?

Thanks, you all!

Bubbis Thedog

:silverha:

• Re: VLOOKUP() Using Multiple Sheets?

do you want to post the file

"Doubt everything. Find your own light." -- Gautama Buddha

• Re: VLOOKUP() Using Multiple Sheets?

I use VLOOKUP alot but I usually set the last parameter to FALSE

=VLOOKUP(A1,ws1!A1:F118,6,FALSE)

If this doesn't work can you post an example.

• Re: VLOOKUP() Using Multiple Sheets?

That was it, carlmack! Thanks for clearing that up for me.

Bubbis Thedog

:silverha:

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!