| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup Value
Try this out:
=OFFSET($A$1,0,MATCH("CC",$A$2:$D$2,0)-1) "Ruan" wrote: I am trying to lookup a value without using the vlookup or hlookup functions, as I am unable to. My data range is in A1:D2. I need to find the corresponding value in row 1 from the lookup_value in row 2. Example: 45 60 35 79 AA BB CC DD The lookup_value is CC. I need the result to be 35. vlookup and hlookup cannot be used in this case. What are my alternatives? Ruan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup looks to the prior column if zero appears in the lookup col | Excel Discussion (Misc queries) | |||
| Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
| Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
| Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Hybrid Mode
