![]() |
|
#3
|
|||
|
|||
|
Here it is.
- Price List sheet is the full table - Options sheet is where the array for the drop down options is - Drop Down sheet is where the form is. The F2 cell is where I wanna insert the formula so the price comes automatically after "reading" the 4 chosen options (B2, C2, D2, E2). Thank you again. |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
a complex IF formula perhaps?
|
robfreeman | Excel | 3 | 05-17-2016 04:58 AM |
| Need formula to determine minimum quantity needed per price | mbking | Excel | 2 | 02-10-2015 01:46 PM |
Complex formula question
|
diverdown87 | Excel | 7 | 10-21-2014 07:44 AM |
| Complex Formula using INDEX and Match needed | OTPM | Excel | 5 | 05-23-2013 01:22 AM |
Complex array formula
|
andrei | Excel | 9 | 02-03-2012 03:40 AM |