LOOKUP Help

  • Thread starter Thread starter Becca
  • Start date Start date
B

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!
 
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,A1:D5,MATCH(A11,A1:D1,0),0)
 
Back
Top