Combine Functions?

  • Thread starter Thread starter BD7447
  • Start date Start date
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.
 
Hi
you can always use something like
=VLOOKUP(VLOOKUP("search_value",A1:C100,3,0),D1:E100,2,0)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VLOOKUP Function and data combined from 2 cells 2
want to track time while paste value in multiple column of same roe 1
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1
resettable, over-ridable, default cell values 0
If and Lookup 6
Excel Concatenate with line breaks but ignore blank cells 3
Search for specific text within last non blank cell in a range 2
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1

Back
Top