| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Results in a column
=IF(C19="","",VLOOKUP(C19,INDIRECT(B19&"List"),2,F ALSE))
col 2 col 3 col 4 col 5 col 6 Absolute Black 12" x 12" tile $3.80 $3.80 $3.80 $3.61 $3.61 In the above formula the number 2 is just showing the price in col 2, i would like it to show all 5 prices in a drop down list. The prices are on a separate sheet. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running total w/2 columns - Excel | Excel Worksheet Functions | |||
| match and count words | Excel Worksheet Functions | |||
| Matching values from two columns and making a third column with the results - possible? | Excel Discussion (Misc queries) | |||
| How do I subtract column 1 from 2 and show results in 3?HELP! | Excel Worksheet Functions | |||
| Subtotal results in new column and then sorting subtotals | Excel Worksheet Functions | |||
Threaded Mode
