Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
LOOKUP problem with non-sorted vector
Hey,
Can anybody tell me how to get around excel's requirement that the lookup vector must have sorted data - if the data isn't sorted it returns an incorrect value. Example: Column A contains: 1,2,3,4,5 Column B contains: 5 blank cells, 4,5,1,3,2 Column C contains: E,D,C,B,A I want to lookup a cell in column B - B8 (1) in column A - A1 and return the corresponding value in column C - C1. Any ideas? Many thanks, AMSH |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup that returns vector(array) | Excel Discussion (Misc queries) | |||
How do I draw 3D vector arithmetic, showing vector subtraction? | Excel Discussion (Misc queries) | |||
Problem with IF condition or vector lookup? | Excel Worksheet Functions | |||
Vector lookup function | Excel Worksheet Functions | |||
Vector lookup function | Excel Worksheet Functions |