|
|
#1
03-16-2018, 03:56 AM
|
|||
|
|||
VLOOKUP help
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 
|
|
|
Similar Threads
|
||||
| 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 |
 vlookup help
|
framedbyhanging | Excel | 7 | 12-31-2014 09:57 PM |
|
Vlookup
|
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 |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode