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!

Hi

=INDEX($A$1:$A$10,MATCH(LookupValue,$C$1:$C$10,0),0)


Arvi Laanemets


"Derek" <[email protected]> wrote in message
news:[email protected]...
> 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!

=INDEX($A$1:$A$10,MATCH(D1,$C$1:$C$10,0))
where D1 holds the value that you would enter

"Derek" <[email protected]> wrote in message
news:[email protected]...
> 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!

=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!