LOOKUP Help

[Becca]

I have a list of 24 people with three different levels of cost information
depending on their relevant 'level' e.g. Carol can have costs of £400, £350
and £500 depending on what level she is working at. I need to be able to look
up and select the right cost, based on trainer name and level, and then this
information to be displayed on a different worksheet. I think i can do this
with look up but am not sure how to do it!

Help!

 

[Don Guillett]

Have a look in the help index for VLOOKUP

 

[T. Valko]

See if this helps.

...........A..........B..........C............D
1................Level1....Level2....Level3
2......Tom......10..........22...........30
3......Sue.......14..........20...........17
4.....Carol......50.........21...........14
5.....Ted........27.........66............33

Lookup Carol Level2

A10 = Carol
A11 = Level2

=VLOOKUP(A10,A15,MATCH(A11,A11,0),0)