|
Validation and Lookup
Im am creating a Price Inquiry tool... I am just having problems when it
comes to the lookup for the prices... I have A1 as the Item Category drop down and B1 as the Item drop down... I want C3 to return the price of the item once B1 already has the exact item to lookup... I created the A1 and B1 as dependent drop down list. A B C 1 Gardening Water Hose Price Need help.. Please advise |
Validation and Lookup
From what i understand is that you want column C to return the price of the
item if column A is selected and column B, you select 'price' from the drop down list. If so, assuming in your database, you have set column E for all the items and column F for all the prices for those items, in column C, try this formula: =IF(B2="Price",INDEX($F$2:$F$4,MATCH(D2,$E$2:$E$4, 0)),"") Change the range as accordingly. Click yes below if this is what you want. "max007" wrote: Im am creating a Price Inquiry tool... I am just having problems when it comes to the lookup for the prices... I have A1 as the Item Category drop down and B1 as the Item drop down... I want C3 to return the price of the item once B1 already has the exact item to lookup... I created the A1 and B1 as dependent drop down list. A B C 1 Gardening Water Hose Price Need help.. Please advise |
Validation and Lookup
Sorry should be =IF(B2="Price",INDEX($F$2:$F$4,MATCH(A2,$E$2:$E$4, 0)),"")
"ck" wrote: From what i understand is that you want column C to return the price of the item if column A is selected and column B, you select 'price' from the drop down list. If so, assuming in your database, you have set column E for all the items and column F for all the prices for those items, in column C, try this formula: =IF(B2="Price",INDEX($F$2:$F$4,MATCH(D2,$E$2:$E$4, 0)),"") Change the range as accordingly. Click yes below if this is what you want. "max007" wrote: Im am creating a Price Inquiry tool... I am just having problems when it comes to the lookup for the prices... I have A1 as the Item Category drop down and B1 as the Item drop down... I want C3 to return the price of the item once B1 already has the exact item to lookup... I created the A1 and B1 as dependent drop down list. A B C 1 Gardening Water Hose Price Need help.. Please advise |
Validation and Lookup
"ck" wrote: Sorry should be =IF(B2="Price",INDEX($F$2:$F$4,MATCH(A2,$E$2:$E$4, 0)),"") "ck" wrote: From what i understand is that you want column C to return the price of the item if column A is selected and column B, you select 'price' from the drop down list. If so, assuming in your database, you have set column E for all the items and column F for all the prices for those items, in column C, try this formula: =IF(B2="Price",INDEX($F$2:$F$4,MATCH(D2,$E$2:$E$4, 0)),"") Change the range as accordingly. Click yes below if this is what you want. "max007" wrote: Im am creating a Price Inquiry tool... I am just having problems when it comes to the lookup for the prices... I have A1 as the Item Category drop down and B1 as the Item drop down... I want C3 to return the price of the item once B1 already has the exact item to lookup... I created the A1 and B1 as dependent drop down list. A B C 1 Gardening Water Hose Price Need help.. Please advise maybe just to add some detail... A B C 1 Price 2 Gardening Water Hose 3 4 Gardening Hardware Price 5 Water Hose Nails 100 6 Fertizer Hammer 50 |
Validation and Lookup
Sorry your example all jumble up and I cannot decipher. Am i correct that you
need to find the price (column C) based on the selection in column A and column B? If so, you can try to use SUMPRODUCT for your 2 criteria. How does your database look like? "max007" wrote: "ck" wrote: Sorry should be =IF(B2="Price",INDEX($F$2:$F$4,MATCH(A2,$E$2:$E$4, 0)),"") "ck" wrote: From what i understand is that you want column C to return the price of the item if column A is selected and column B, you select 'price' from the drop down list. If so, assuming in your database, you have set column E for all the items and column F for all the prices for those items, in column C, try this formula: =IF(B2="Price",INDEX($F$2:$F$4,MATCH(D2,$E$2:$E$4, 0)),"") Change the range as accordingly. Click yes below if this is what you want. "max007" wrote: Im am creating a Price Inquiry tool... I am just having problems when it comes to the lookup for the prices... I have A1 as the Item Category drop down and B1 as the Item drop down... I want C3 to return the price of the item once B1 already has the exact item to lookup... I created the A1 and B1 as dependent drop down list. A B C 1 Gardening Water Hose Price Need help.. Please advise maybe just to add some detail... A B C 1 Price 2 Gardening Water Hose 3 4 Gardening Hardware Price 5 Water Hose Nails 100 6 Fertizer Hammer 50 |
Validation and Lookup
"ck" wrote: Sorry your example all jumble up and I cannot decipher. Am i correct that you need to find the price (column C) based on the selection in column A and column B? If so, you can try to use SUMPRODUCT for your 2 criteria. How does your database look like? "max007" wrote: "ck" wrote: Sorry should be =IF(B2="Price",INDEX($F$2:$F$4,MATCH(A2,$E$2:$E$4, 0)),"") "ck" wrote: From what i understand is that you want column C to return the price of the item if column A is selected and column B, you select 'price' from the drop down list. If so, assuming in your database, you have set column E for all the items and column F for all the prices for those items, in column C, try this formula: =IF(B2="Price",INDEX($F$2:$F$4,MATCH(D2,$E$2:$E$4, 0)),"") Change the range as accordingly. Click yes below if this is what you want. "max007" wrote: Im am creating a Price Inquiry tool... I am just having problems when it comes to the lookup for the prices... I have A1 as the Item Category drop down and B1 as the Item drop down... I want C3 to return the price of the item once B1 already has the exact item to lookup... I created the A1 and B1 as dependent drop down list. A B C 1 Gardening Water Hose Price Need help.. Please advise maybe just to add some detail... A B C 1 Price 2 Gardening Water Hose 3 4 Gardening Hardware Price 5 Water Hose Nails 100 6 Fertizer Hammer 50 the table looks well on the reply window.. :) i really appreciate your time and effort in helping me |
Validation and Lookup
Is it something like this?
A B C 1 Price 2 Gardening Water Hose Water Hose 100 3 Gardening Hardware Nails 50 4 Gardening Hardware Hammer 20 5 Gardening Hardware Fertizer 10 6 "max007" wrote: "ck" wrote: Sorry your example all jumble up and I cannot decipher. Am i correct that you need to find the price (column C) based on the selection in column A and column B? If so, you can try to use SUMPRODUCT for your 2 criteria. How does your database look like? "max007" wrote: "ck" wrote: Sorry should be =IF(B2="Price",INDEX($F$2:$F$4,MATCH(A2,$E$2:$E$4, 0)),"") "ck" wrote: From what i understand is that you want column C to return the price of the item if column A is selected and column B, you select 'price' from the drop down list. If so, assuming in your database, you have set column E for all the items and column F for all the prices for those items, in column C, try this formula: =IF(B2="Price",INDEX($F$2:$F$4,MATCH(D2,$E$2:$E$4, 0)),"") Change the range as accordingly. Click yes below if this is what you want. "max007" wrote: Im am creating a Price Inquiry tool... I am just having problems when it comes to the lookup for the prices... I have A1 as the Item Category drop down and B1 as the Item drop down... I want C3 to return the price of the item once B1 already has the exact item to lookup... I created the A1 and B1 as dependent drop down list. A B C 1 Gardening Water Hose Price Need help.. Please advise maybe just to add some detail... A B C 1 Price 2 Gardening Water Hose 3 4 Gardening Hardware Price 5 Water Hose Nails 100 6 Fertizer Hammer 50 the table looks well on the reply window.. :) i really appreciate your time and effort in helping me |
| All times are GMT +1. The time now is 01:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com