VLOOKUP using MATCH

Resolved · Low Priority · Version 2013

Wed 23 May 2018, 12:51 Delegate Laura said...

Laura has attended:
Excel Advanced course

VLOOKUP using MATCH

Hi,

I'm trying to use MATCH in a VLOOKUP where I'm looking from one sheet to another and need to drag the formula across and also down the list. So for example:

I have 6 columns of data that I need to look up to in "sheet 6" to populate in "sheet 1", each matching the heading of the sheet I want to do the VLOOKUP in (cells E2:J2). There is data underneath all of the headers in "sheet 6" that I need to pull into "sheet 1".

I need to lookup against a store number which are listed in column C of both reports

I am getting some data through in sheet 1 but it looks like it's just pulling the store number from column C in sheet 6, not the data underneath the headed column.

Thu 24 May 2018, 22:04 Trainer Wendy said...

RE: VLOOKUP using MATCH

Hi Laura

Thank you for using our forum

I think this may be a problem related to using the correct absolute/mixed referencing

Could you perhaps send the files to info@stl-training.co.uk so we can get a better look at how you're using the information?

Kind regards
Wendy Canelas
Microsoft Office Trainer

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Display Functions on Worksheets

Functions in Excel can be difficult to recall their format/syntax

For example, you want to use the =PMT function.

Enter =PMT, then select keystroke, CTRL+SHIFT+A.

This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function

View all Excel hints and tips