Vlookup and Match

beginner · #1 06-19-2015, 10:24 AM

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

beginner · #2 06-19-2015, 01:12 PM

If you have more columns, you can try this formulas

In to cell B3 and copy down (If you want quickly copying formula down, double click mouse to Fill handle)

Code:

=IFERROR(VLOOKUP($A3;INDIRECT("Sheet2!"&SUBSTITUTE(ADDRESS(2;COLUMN(A1);1);"0";"")&":$H$8544");MATCH(B$1;Sheet2!$A$1:$F$1;0);0);"")

In to cell C3 copy to right and copy all down

Code:

=IFERROR(VLOOKUP($A3;INDIRECT("Sheet2!"&SUBSTITUTE(ADDRESS(2;COLUMN(B1)+COLUMN(A1);1);"0";"")&":$H$8544");MATCH(C$1;INDIRECT("Sheet2!"&SUBSTITUTE(ADDRESS(1;COLUMN(A1)+COLUMN(B1);1);"0";"")&":$H$1");0);0);"")

Please see attach

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