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!
--
Rebecca Foreman

Have a look in the help index for VLOOKUP

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Becca" wrote in message
...
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!
--
Rebecca Foreman

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)

--
Biff
Microsoft Excel MVP


"Becca" wrote in message
...
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!
--
Rebecca Foreman