IF AND LOOKUP

S

Stuart WJG

I have 3 lists in 3 different worksheets named Aluminiuim Titanium &
Stainless Steel
I have in cell i3 on diferent worksheet a drop down list to select A,B or C
In j3 there is an varible number input
In C1 I want to put the result of looking up what is in A1 to point to
corresponding worksheet and then lookup what is in B1 and put in C! what is
2 cells from the B1 value.
I have tried a combination of if and look up and it does not work as shown
below
=IF('Data Entry'!I3="Aluminium",VLOOKUP('Data
Entry'!J3,Aluminium!A1:C37,2,IF('Data Entry'!I3="Titanium",VLOOKUP('Data
Entry'!J3,Titanium!A3:C39,2,IF('Data Entry'!I3="Stainless
Steel",VLOOKUP('Data Entry'!J3,'Stainless Steel'!A3:C39,2))))))
Can somebody help
 

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

Word macro that can call cells out of Excel for a find and replace 0
I can not seem to get my IF / AND statement to work, help please 3
how do I use one drop-list to modify another drop-lists options? 3
Lookup problems? 1
how to find text vaues for a given grade? 0
color after depending on 1st value in a cell 1
how to apply the code to the whole of the worksheet? 1
Compute Additional Hours Needed Using "if" or "lookup" 1

Top