Hi All,
I understand how VLOOKUP works but I have a sheet where the result I want returned is in efect column -3. eg VLOOKUP(A1,DATA,-3,0)
Do I need to use a different function or can VLOOKUP return the result of a negative column.
Thanks in anticipation of you help.
Andy
Use INDEX/MATCH combo
Assuming your data starts in Column D and you want values from Column B use
=INDEX(B:B,Match(A1,Data,0))
Is thsi something you can work with?
Life's a spreadsheet, Excel!
Say thanks, Click *
If you like VLOOKUP try
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks