| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
at, if statement with text, such as if(product), then (price)
I have a price list with descriptions, item codes and prices. I just want to
use something simple like an at, if statement to tell the worksheet if this product is selected from my drop down list, then return this price and item code. I'm sure this is so simple, but I'm not having any luck. Please help Thanks |
|
#2
|
|||
|
|||
|
Assuming the Dropdown is in B2, and the price list is in M1:O20
=VLOOKUP(B2,$M$1:$O$209,2,False) and =VLOOKUP(B2,$M$1:$O$209,3,False) -- HTH RP (remove nothere from the email address if mailing direct) "karenofcourse" wrote in message ... I have a price list with descriptions, item codes and prices. I just want to use something simple like an at, if statement to tell the worksheet if this product is selected from my drop down list, then return this price and item code. I'm sure this is so simple, but I'm not having any luck. Please help Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if statement with text | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| If statement for text | Excel Worksheet Functions | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Hybrid Mode
