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
Re: VLOOKUP() Using Multiple Sheets?
to the best of my knowledge, lookups should work with even different workbooks.
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
Re: VLOOKUP() Using Multiple Sheets?
do you want to post the file
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
Don’t have an account yet? Register yourself now and be a part of our community!
