Two layer of vlookup issue

		Microsoft Office Forums > Microsoft Excel > Excel
Two layer of vlookup issue

FAQ

Thread Tools

Display Modes

08-06-2013, 01:45 AM

jolinchew

Windows 7 32bit Two layer of vlookup issue

Office 2010 32bit

Novice

Join Date: Jul 2013

Posts: 11

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?

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using Vlookup & IF together	thelauncher	Excel	5	08-25-2013 11:32 PM
IF and VLOOKUP	SBMC	Excel	1	11-07-2012 10:24 AM
Vlookup	kkerr	Excel	6	08-31-2012 01:23 AM
Vlookup	ibrahimaa	Excel	5	03-04-2012 11:24 AM
Help with VLOOKUP	sakhtar	Excel	2	07-24-2010 07:39 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:50 AM.