Thread: How can I return Vlookup only if Specific Criteria is met in 1 column of the Vlookup Array
View Single Post
 
Old 01-20-2018, 08:48 PM
EcommDOC EcommDOC is offline Windows 10 Office 2016
Novice
  
Join Date: Jan 2018
Posts: 2
EcommDOC is on a distinguished road
Default 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
Attached Images
File Type: png Capture.PNG (74.9 KB, 25 views)
File Type: png Destination Sheet.PNG (80.5 KB, 25 views)
Last edited by EcommDOC; 01-20-2018 at 08:51 PM. Reason: Clarification
Reply With Quote