Vlookup formula
Hi,
I need a nested formula like vlookup formula. This is my problem: I have 8 size of drainage pipes differ by diameter, and every size have three grades of prices as shown in the table below: Diameter type A type B type C 40 $50 $70 $90 50 $60 $85 $105 80 $85 $110 $135 100 $125 $165 $195 125 $195 $240 $310 150 $310 $425 $580 180 $550 $720 $950 225 $835 $1150 $1650 Now I have a formula that calculate all the cost of performing new system of drainage pipes (excavating, materials, labor, est., and I need a nested formula to bring in the price of the correct pipe, for example, if I will type in one cell 100 and the other B, the formula will bring to me the value $165 according to the table above. Any help? Thanks, Amnon -- --------------------------------------------------------------------- "Are you still wasting your time with spam?... There is a solution!" Protected by GIANT Company's Spam Inspector The most powerful anti-spam software available. http://mail.spaminspector.com |
With your table of values in A1:D9
The diameter cell being A12, The type cell being A13, =VLOOKUP(A12,A2:D9,MATCH(B12,A1:D1,FALSE)) Regards, "Amnon Wilensky" wrote in message ... Hi, I need a nested formula like vlookup formula. This is my problem: I have 8 size of drainage pipes differ by diameter, and every size have three grades of prices as shown in the table below: Diameter type A type B type C 40 $50 $70 $90 50 $60 $85 $105 80 $85 $110 $135 100 $125 $165 $195 125 $195 $240 $310 150 $310 $425 $580 180 $550 $720 $950 225 $835 $1150 $1650 Now I have a formula that calculate all the cost of performing new system of drainage pipes (excavating, materials, labor, est., and I need a nested formula to bring in the price of the correct pipe, for example, if I will type in one cell 100 and the other B, the formula will bring to me the value $165 according to the table above. Any help? Thanks, Amnon -- --------------------------------------------------------------------- "Are you still wasting your time with spam?... There is a solution!" Protected by GIANT Company's Spam Inspector The most powerful anti-spam software available. http://mail.spaminspector.com |
One way:
=VLOOKUP(cell1,A1:D9,MATCH(cell2,{"A","B","C"},FAL SE)+1,FALSE) In article , "Amnon Wilensky" wrote: Hi, I need a nested formula like vlookup formula. This is my problem: I have 8 size of drainage pipes differ by diameter, and every size have three grades of prices as shown in the table below: Diameter type A type B type C 40 $50 $70 $90 50 $60 $85 $105 80 $85 $110 $135 100 $125 $165 $195 125 $195 $240 $310 150 $310 $425 $580 180 $550 $720 $950 225 $835 $1150 $1650 Now I have a formula that calculate all the cost of performing new system of drainage pipes (excavating, materials, labor, est., and I need a nested formula to bring in the price of the correct pipe, for example, if I will type in one cell 100 and the other B, the formula will bring to me the value $165 according to the table above. Any help? Thanks, Amnon |
Sorry, that should be
=VLOOKUP(A12,A2:D9,MATCH(B12,A1:D1),FALSE) Regards, "Alan" wrote in message ... With your table of values in A1:D9 The diameter cell being A12, The type cell being A13, =VLOOKUP(A12,A2:D9,MATCH(B12,A1:D1,FALSE)) Regards, "Amnon Wilensky" wrote in message ... Hi, I need a nested formula like vlookup formula. This is my problem: I have 8 size of drainage pipes differ by diameter, and every size have three grades of prices as shown in the table below: Diameter type A type B type C 40 $50 $70 $90 50 $60 $85 $105 80 $85 $110 $135 100 $125 $165 $195 125 $195 $240 $310 150 $310 $425 $580 180 $550 $720 $950 225 $835 $1150 $1650 Now I have a formula that calculate all the cost of performing new system of drainage pipes (excavating, materials, labor, est., and I need a nested formula to bring in the price of the correct pipe, for example, if I will type in one cell 100 and the other B, the formula will bring to me the value $165 according to the table above. Any help? Thanks, Amnon -- --------------------------------------------------------------------- "Are you still wasting your time with spam?... There is a solution!" Protected by GIANT Company's Spam Inspector The most powerful anti-spam software available. http://mail.spaminspector.com |
Not my day!
The type cell should be B12, Regards. "Alan" wrote in message ... Sorry, that should be =VLOOKUP(A12,A2:D9,MATCH(B12,A1:D1),FALSE) Regards, "Alan" wrote in message ... With your table of values in A1:D9 The diameter cell being A12, The type cell being A13, =VLOOKUP(A12,A2:D9,MATCH(B12,A1:D1,FALSE)) Regards, "Amnon Wilensky" wrote in message ... Hi, I need a nested formula like vlookup formula. This is my problem: I have 8 size of drainage pipes differ by diameter, and every size have three grades of prices as shown in the table below: Diameter type A type B type C 40 $50 $70 $90 50 $60 $85 $105 80 $85 $110 $135 100 $125 $165 $195 125 $195 $240 $310 150 $310 $425 $580 180 $550 $720 $950 225 $835 $1150 $1650 Now I have a formula that calculate all the cost of performing new system of drainage pipes (excavating, materials, labor, est., and I need a nested formula to bring in the price of the correct pipe, for example, if I will type in one cell 100 and the other B, the formula will bring to me the value $165 according to the table above. Any help? Thanks, Amnon -- --------------------------------------------------------------------- "Are you still wasting your time with spam?... There is a solution!" Protected by GIANT Company's Spam Inspector The most powerful anti-spam software available. http://mail.spaminspector.com |
All times are GMT +1. The time now is 11:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com