Vlookup and Match

		Microsoft Office Forums > Microsoft Excel > Excel
Vlookup and Match

06-19-2015, 10:07 AM

beginner

Windows 7 32bit Vlookup and Match

Office 2013

Advanced Beginner

Join Date: Sep 2011

Location: Europe

Posts: 45

Quote:

Originally Posted by ExcelVlookup

It would be very nice if someone could help me.

If I understand you, try this formula

On Sheet1 in to cell B3 put this formula and copy to right and to down to last row

Code:

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

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 01:29 AM.