|
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
01-20-2018, 08:48 PM
|
|||
|
|||
How can I return Vlookup only if Specific Criteria is met in 1 column of the Vlookup Array
What I need to do here is take the vlookup and separate into 2 separate price points. Price Point 1 would return in columns E:J, then Price Point 2 would return in columns L:K. I've attache the 2 sheets that I'm working with.
I have the formula:=IFERROR(VLOOKUP($B$2&":"&D3,'Picklist by Individual Unit Qty'!B1:K8603,5,FALSE),"") BUT, I need to return the value only if column K on the lookup sheet matches a specific criteria which appears in cell A13 of Destination sheet. Any Ideas Last edited by EcommDOC; 01-20-2018 at 08:51 PM. Reason: Clarification 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Using a VLOOKUP - when 2 rows match criteria it returns the first value in the cel only how 2 change | djrobst | Excel | 4 | 10-28-2015 01:32 AM |
| Would like to return a row rather than a cell using VLookup | canajun | Excel | 7 | 12-10-2014 01:03 PM |
| Vlookup two columns return 3rd | jennamae | Excel | 11 | 01-12-2014 02:53 AM |
| excel vlookup with multiple criteria | mpokorny | Excel | 4 | 05-06-2012 04:06 AM |
 Vlookup or Index/Match - Multiple Criteria
|
ruci1225 | Excel | 1 | 01-15-2012 07:31 AM |
Windows 10 
Office 2016
Threaded Mode