Bart
Member
Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
|
Im after some excel help if possible.
I have 2 sheets called Materials and Prices.
On the Materials
Cells A1 to A50 contains a list of materials,
Cells B1 to B50 contains prices
Cells C1 to C50 contains hours (just a plain number).
On the Prices page;
Column A1 to A10 is a drop down menu (using data validation) of cells A1 to A50 on the materials sheet, so I can select a list of materials.
What im now trying to achieve is get cells B1 to B10 to lookup the prices on the materials page based on what cell is chosen in column A.
I think it needs to compare the value between [prices]A1-A10 against [materials]A1-A50 and associate the prices with each.
Anyone know if this is possible?
|
RichR
Premium Member
Registered: 17th Oct 01
Location: Waterhouses, Staffordshire
User status: Offline
|
"If" function? it'd be a hell of a long function but would work based on the content of colum A
=IF(D34="CSM 300",'Material Specification'!$G$19,IF(D34="CSM 600",'Material Specification'!$G$20,IF(D34="DUOMAT",'Material Specification'!$G$21,IF(D34="KEVLAR",'Material Specification'!$G$24,IF(D34="TREVIRA CORE",'Material Specification'!$G$31,"Enter Value")))))
Simple if function I rote for inputting the fibreweight fraction based on the content of the box in column D; which was the Fibreglass material type - you'll have 50 functions though, based on the 50 functions and corresponding price
I think your limited on number of functions though doing it that way; so you might not be able to do it for 50 but I think it might be 64 so you might be okay 
[Edited on 08-09-2010 by LiVe LeE]
|
Neo
Member
Registered: 20th Feb 07
Location: Essex
User status: Offline
|
I think I would simply do a lookup, use sheet 2 as your array.
|
Bart
Member
Registered: 19th Aug 02
Location: Midsomer Norton, Bristol Avon
User status: Offline
|
=VLOOKUP(B7,Materials!A7:B67,2,FALSE)
Does the job 
|
Neo
Member
Registered: 20th Feb 07
Location: Essex
User status: Offline
|
|
|
