Lookup question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

schizoid_man - 24 Aug 2007 14:29 GMT

I have a table that has three columns - Name, X and Y. The Names are
is in ascending alphabetical order, X and Y are numeric columns.

I want to lookup a certain value of X and return the corresponding
Name, and repeat the same procedure with Y.

Because I'm not querying the first column VLOOKUP() just doesn't cut
it. Would appreciate any help.

Thx,
Schiz

Reply to this Message

Dave Peterson - 24 Aug 2007 14:38 GMT

You could use =index(match())

Take a look at Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions03.html

> I have a table that has three columns - Name, X and Y. The Names are
> is in ascending alphabetical order, X and Y are numeric columns.
[quoted text clipped - 7 lines]
> Thx,
> Schiz

Signature

Dave Peterson

Reply to this Message

Schizoid Man - 26 Aug 2007 15:42 GMT

> You could use =index(match())
>
> Take a look at Debra Dalgleish's notes:
> http://www.contextures.com/xlFunctions03.html

Thanks for the tip, Dave. Works like a charm!

Reply to this Message

Rate this thread: