Home |
Search |
Today's Posts |
#1
|
|||
|
|||
lookup unsorted list
Hi,
In column A I have a list of product items. In column B I wish to place a rank on a few (not all) of these items, and not in an ascending order from the top of the page. Using this data, I wish to automatically take the ranked items from this table and place in their correct order in another table. ie Column A Column B Trudi 3 Simon Anton 4 Stacey 1 Renee Karen 2 The Result I am aiming for in a different part of the spreadsheet, while leaving this information alone, is Stacey 1 Karen 2 Trudi 3 Anton 4 I thought I could use the lookup function, but this requires the list to be sorted in an ascending order, something that I am unable to do. Is anyone able to provide a neat solution for this problem. Thanks |
#3
|
|||
|
|||
lookup unsorted list
Just curious, why do you say you can't sort your original table in ascending/
descending order? Is it coz you don't want to disturb the original list? If not, there is actually a way to sort it. Let me know if you need to know how. "sslenterprises" wrote: Hi, In column A I have a list of product items. In column B I wish to place a rank on a few (not all) of these items, and not in an ascending order from the top of the page. Using this data, I wish to automatically take the ranked items from this table and place in their correct order in another table. ie Column A Column B Trudi 3 Simon Anton 4 Stacey 1 Renee Karen 2 The Result I am aiming for in a different part of the spreadsheet, while leaving this information alone, is Stacey 1 Karen 2 Trudi 3 Anton 4 I thought I could use the lookup function, but this requires the list to be sorted in an ascending order, something that I am unable to do. Is anyone able to provide a neat solution for this problem. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching unsorted lookup values | Excel Worksheet Functions | |||
LOOP - Adddress List -to email | Excel Discussion (Misc queries) | |||
How to lookup the dates of a list that are only the first of the . | Excel Worksheet Functions | |||
Lookup closest number in list | Excel Discussion (Misc queries) | |||
double lookup, nest, or macro? | Excel Worksheet Functions |