![]() |
#1
|
|||
|
|||
![]()
Hey All,
I've created an price proposal template where I want to select a customer type, fill in product ID and let the sheet look up the rest in a second TAB. The only problem is: I can't seem to get the correct price tab working. Can someone please help me? here's the excel example. the problem is in de K. Now using this formula: =IF(B19="";"";VLOOKUP(B19;Disposables!B4:Q7;5;0)) the '5' should become 11, 13 or 15 corresponding the customer type chosen in D4 http://www.filedropper.com/voorbeeldpriceproposal |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
How can I return Vlookup only if Specific Criteria is met in 1 column of the Vlookup Array | EcommDOC | Excel | 7 | 01-22-2018 11:00 AM |
![]() |
framedbyhanging | Excel | 7 | 12-31-2014 09:57 PM |
![]() |
ibrahimaa | Excel | 5 | 03-04-2012 11:24 AM |
Vlookup | ibrahimaa | Excel | 8 | 01-03-2012 09:32 PM |
Vlookup | Karen615 | Excel | 4 | 09-12-2011 02:30 PM |