Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet function Vlookup
Hi,
I am using the vlookup function so that I can find prices of various products. I want to make vlookup to search from bottom to top and not the other way around. How can I do that? Thanks in advance, Antonis. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet function Vlookup
AFAIK you cannot, the only possible option would be to pre-sort the list in
reverse order. If you do not have a column that will obviously sort the list then add a helper column, fill it with a numerical sequence and sort that in descending order. -- Cheers Nigel "Antonis" wrote in message ... Hi, I am using the vlookup function so that I can find prices of various products. I want to make vlookup to search from bottom to top and not the other way around. How can I do that? Thanks in advance, Antonis. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet function Vlookup
Maybe you can use a different function:
Say your table is in Sheet2!A1:B200 and your value to look up is in sheet1!a1. Then put this formula in B1 of Sheet1 and you'll get that last value. =INDEX(Sheet2!B1:B200,LOOKUP(2,1/(Sheet2!A1:A200=A1),ROW(A1:A200))) Adjust the ranges (all of them), but don't use the whole column. Antonis wrote: Hi, I am using the vlookup function so that I can find prices of various products. I want to make vlookup to search from bottom to top and not the other way around. How can I do that? Thanks in advance, Antonis. -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet function Vlookup
Dear Antonis
You cannot get vlookup to work from bottom to top, but you could reverse the order of your data or write a vlookup function yourself. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet function Vlookup
Thank you for the immediate response.
I have sorted my data the other way around and everything works fine now. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP worksheet function returns zero for empty cells | Excel Worksheet Functions | |||
Excel VLOOKUP hyperlink to mailto function on different worksheet | Excel Worksheet Functions | |||
Vlookup worksheet function | Excel Worksheet Functions | |||
How to use a cell value as Table Array in VLOOKUP worksheet function | Excel Discussion (Misc queries) | |||
Application Worksheet Function Vlookup error | Excel Programming |