asked on

Lookup table

Please help (once again...!)
I need to retrieve an element from a cell block but cannot get it right.

I have the following on an EXCEL worksheet

V7      P7      W7      P4      L7
AES      ZZA      MMG      IVB      MMA
IID      ZZB      MMH      IVF      MMB
IIG      ZZC      MMI      IVI      MMC
IIJ            MMJ      IVM      MMD
IIK            MMK      IVO      MME
IIN            MML      IVR      MMF
IIS            MMM      IVS
IIT            MMN      IVW
IIU            MMO      IVX
IIV            MMP      IVY
IIW                  IVZ
IIX                  NLE
IIY                  NLF
                  NLK
                  NLN
                  NLO
                  NLP
                  NLS
                  NLT
                  NLV
                  NLW
                  NLX
                  NLY
                  NLZ
                  YGB
                  YGE





The data being supplied is one of the values AES, IVX etc. etc. and what I want is the value at the top of the appropriarte column (ie one of P4, W7, P7 etc.)
How do I use the appropriate lookup and reference functions to extract the value at the top of the column, given the value supplied.
Note that the number of values in each column is not constant and that the values are not in sorted order, although this could be done if it makes the solution easier.

Big points available for the first person to get it right

SRigney

I don't know excel well enough to provide the solution, but I can give you a quick logic approach that you can try.

Find the item that you are looking for. I would guess that Excel provides a find function that returns a cell.

When you know the cell that you are in then you need to look in the first row of the same colum to get it's value.

Of course what I'm saying may be what you already know.

SOLUTION

g0rath

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

MADisonMAN

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

GSD4ME

ASKER

Thanks to the pair of you for the answer - exactly what I wanted.
Points have been split evenly