Combine Functions?

B

BD7447

I don't know whether I should be using an 'IF' or 'VLOOKUP' function, or a
combination of both.

What I'm trying to achieve is to have a cell look at the value of another cell
and, dependant upon that value, look up a third range of cells.

I would have used an 'IF' function for each of the cells I want to populate,
but there are more than 7 values in the initial lookup cell.

If anyone can spare the time to help, it might be easier to look at what I'm
trying to achieve. This can be seen at: http://www.suqs.co.uk/sample.htm

Many thanks for any assistance.
 
F

Frank Kabel

Hi
you can always use something like
=VLOOKUP(VLOOKUP("search_value",A1:C100,3,0),D1:E100,2,0)
 
B

BD7447

Many thanks for the pointer. At least it got me looking further into VLOOKUP.
I finally got this to work by using the following formula:

=VLOOKUP(B2,J4:O11,2,FALSE)

Probably a bit basic to many of you, but a real learning curve for this
beginner.

Regards
 
Top