Hi,
I'm stuck on retrieving col_index_num from another sheet. With table_array everything is ok, it looks in Sheet2, but I can't seem to take column from Sheet2, it always takes it from Sheet1).
Formula is in Sheet1:
=VLOOKUP(A1; Sheet2!B1:B114; 1; FALSE)
I want to take 1st column value where it finds that match from Sheet2
Thanks for your advice.
Last edited by drakaz; 03-07-2012 at 10:44 AM.
Do you really want:
=VLOOKUP(A1; Sheet2!A1:B114; 2; FALSE)
or
=INDEX(Sheet2!A1:A114;MATCH(A1; Sheet2!B1:B114; FALSE))
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
=INDEX(Sheet2!A1:A114;MATCH(A1; Sheet2!B1:B114; FALSE)) - this one, thanks!
I really need to learn INDEX function...
Here is a great place to learn: http://www.contextures.com/xlfunctions03.html
Thank you once more
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks