I want to design a sheet that will allow me to select components, manufacturers for a P.C.(from a validate list)and automatically select the correct price. I've tried vlookup but couldn't get it to work. The sheet will look something like this.
cell a3-20 = component(cpu,ram,printers,etc)
cell b3 = manufacturers(vlookup?)
cell c3 = model(vlookup?)
cell c4 = price
this data is is a separate sheet in the following format....
Column A
manufacturer
component(type of board P4 or AMD)
model
column B
prices
column A Column B
Chaintech Excel blank
P4 blank
9BIA0 intel 845 Price
9BJA0, Intel 845 Price
9BJD, Intel845 Price
Socket 370 (celeron) blank
6AJA4T-G100, VIA 694X price
6VJD2 VIA PRO 266
Socket A (athlon,Duron)
LAN/MODEM COMBO CARD/ACR SLOT
7AJA2,VIA 8363A
7VJDA, VIA KT266
VIA (RB) -- 2 year warranty
P4-478
ES676B
ASUS
P4-423
P4T, Skt 423
P4TM, SKT423
cell a3-20 = component(cpu,ram,printers,etc)
cell b3 = manufacturers(vlookup?)
cell c3 = model(vlookup?)
cell c4 = price
this data is is a separate sheet in the following format....
Column A
manufacturer
component(type of board P4 or AMD)
model
column B
prices
column A Column B
Chaintech Excel blank
P4 blank
9BIA0 intel 845 Price
9BJA0, Intel 845 Price
9BJD, Intel845 Price
Socket 370 (celeron) blank
6AJA4T-G100, VIA 694X price
6VJD2 VIA PRO 266
Socket A (athlon,Duron)
LAN/MODEM COMBO CARD/ACR SLOT
7AJA2,VIA 8363A
7VJDA, VIA KT266
VIA (RB) -- 2 year warranty
P4-478
ES676B
ASUS
P4-423
P4T, Skt 423
P4TM, SKT423