Thread: [Solved] Two layer of vlookup issue
View Single Post
 
Old 08-06-2013, 01:45 AM
jolinchew jolinchew is offline Windows 7 32bit Office 2010 32bit
Novice
  
Join Date: Jul 2013
Posts: 11
jolinchew is on a distinguished road
Default Two layer of vlookup issue
I have one excel file below:
document number line item Z
1000020 01
1000020 05

it will vlookup another excel file and get value column below:
document number line item value
1000020 02 300
1000020 01 400

if I vlookup document number, my Z column for first record will be 300, which is wrong, I want vlookup by document number and line item together, how to do?
Reply With Quote