Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Backwards lookup
Sorry if this is a repost--- The first one may not have actually made it.
I have an array A1:C10 on an existing worksheet. I need a look up function where by I can enter a vlue that would be found in ColC and return the corresponding value from ColA. Can this be done without having to copy and paste a new table with the standard vlookup orientation? Thanks! |
#2
|
|||
|
|||
Hi
=INDEX($A$1:$A$10,MATCH(LookupValue,$C$1:$C$10,0), 0) Arvi Laanemets "Derek" wrote in message ... Sorry if this is a repost--- The first one may not have actually made it. I have an array A1:C10 on an existing worksheet. I need a look up function where by I can enter a vlue that would be found in ColC and return the corresponding value from ColA. Can this be done without having to copy and paste a new table with the standard vlookup orientation? Thanks! |
#3
|
|||
|
|||
=INDEX($A$1:$A$10,MATCH(D1,$C$1:$C$10,0)) where D1 holds the value that you would enter "Derek" wrote in message ... Sorry if this is a repost--- The first one may not have actually made it. I have an array A1:C10 on an existing worksheet. I need a look up function where by I can enter a vlue that would be found in ColC and return the corresponding value from ColA. Can this be done without having to copy and paste a new table with the standard vlookup orientation? Thanks! |
#4
|
|||
|
|||
=index(A1:A10,Match(value,C1:c10,0))
"Derek" wrote: Sorry if this is a repost--- The first one may not have actually made it. I have an array A1:C10 on an existing worksheet. I need a look up function where by I can enter a vlue that would be found in ColC and return the corresponding value from ColA. Can this be done without having to copy and paste a new table with the standard vlookup orientation? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Lookup Lookup | Excel Worksheet Functions | |||
Lookup Function Problem | Excel Discussion (Misc queries) | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
Excel Lookup Functions | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |