|
|
|
|
#1
02-14-2017, 03:21 AM
|
|||
|
|||
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. 
|
|
#3
02-14-2017, 04:07 AM
|
|||
|
|||
|
NICE! Thanks a lot.
PS. is there a way of obtaining the same result without using CONCAT?
|
|
| Thread Tools | |
| Display Modes | |
|
|
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 |
Windows 10 
Office 2016
Hybrid Mode