| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup - not sorted?
I need to lookup values in an array, but my data is not sorted in any order.
We use unique identifiers but they are not always in any kind of order, and it would not be useful to us to use them in ascending or descending order. How can I lookup the "Original Body Text" in one sheet and paste into another using the GUID as my ID? Thanks!!! GUID Original Body Text L2-ME-9468039 Adding a new Neighborhood record... L2-ME-9755815 In Pathways, Neighborhood records ... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Lookup - not sorted?
Your data does not need to be sorted if it is an exact match you are looking
for. Use VLOOKUP() and specify FALSE for [range_lookup]. For example: =VLOOKUP("L2-ME-9468039",<your table range,2,FALSE) -- Regards, Dave "Kristin" wrote: I need to lookup values in an array, but my data is not sorted in any order. We use unique identifiers but they are not always in any kind of order, and it would not be useful to us to use them in ascending or descending order. How can I lookup the "Original Body Text" in one sheet and paste into another using the GUID as my ID? Thanks!!! GUID Original Body Text L2-ME-9468039 Adding a new Neighborhood record... L2-ME-9755815 In Pathways, Neighborhood records ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Another way to lookup data | Excel Worksheet Functions | |||
| Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
| Lookup thinks data isn't sorted | Excel Worksheet Functions | |||
| Lookup function w/Text and Year | Excel Worksheet Functions | |||
| double lookup, nest, or macro? | Excel Worksheet Functions | |||
Linear Mode
