Vlookup and Match

		Microsoft Office Forums > Microsoft Excel > Excel
Vlookup and Match

06-19-2015, 10:24 AM

beginner

Windows 7 32bit Vlookup and Match

Office 2013

Advanced Beginner

Join Date: Sep 2011

Location: Europe

Posts: 45

Or try

In to cell B3

Code:

=IFERROR(VLOOKUP($A3;Sheet2!$A$2:$F$8544;MATCH(B$1;Sheet2!$A$1:$F$1;0);0);"")

In to cell C3

Code:

=IFERROR(VLOOKUP($A3;Sheet2!$C$2:$F$8544;MATCH(C$1;Sheet2!$C$1:$F$1;0);0);"")

In to cell D3

Code:

=IFERROR(VLOOKUP($A3;Sheet2!$E$2:$F$8544;MATCH(D$1;Sheet2!$E$1:$F$1;0);0);"")

etc

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
vlookup or match	uhlersa	Excel	2	12-04-2012 12:35 AM
Match Index with sumproduct/vlookup	angie.chang	Excel	1	06-18-2012 08:47 AM
Vlookup or Index/Match - Multiple Criteria	ruci1225	Excel	1	01-15-2012 07:31 AM
Vlookup, offset, match & countif	jujuwillis	Excel	2	10-15-2011 11:06 AM
Vlookup and If conditions together along with match formulas	david_benjamin	Excel	2	04-11-2011 11:30 AM

Other Forums: Access Forums

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