Lookup question

[schizoid_man]

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

 

[Dave Peterson]

You could use =index(match())

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

 

[Schizoid Man]

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!