Vlookup to impress my boss

Hi there guys and gals,

I need to use a vlookup function (I think!!) to impress my boss and I hope that someone here can assist (kudos will go to you of course!!) I have 2 spreadsheets with 3 columns each, one spreadsheet for May and one for June. I would like the formula to return results in the 4th and 5th column of the June spreadsheet by looking for the same number in column A and returning the corresponding cells in the next two columns of the May spreadsheet. In other words I need to compare June figures to May's (column B and C in both sheets) based on a common product number (Column A in both sheets). I hope this makes sense!! Pls ask if you need clarification.

I have now attached the workbook and would like the results to appear in the yellow highlighter area...Hope this helps



Shanka

You get better help if you post an Excel-example of your workbook, without confidential information.

Make sure the workbook demonstrates your desired results if possible, or just highlight the cells you're trying to fix.

Use BEFORE/AFTER sheets if that helps make it clearer.

I think that can be done.

There are 3 worksheets or 3 workbooks?

I made a defined name for the month may.

Don't work with merged cells, you get problem with it in future use.

Please add in your text that you hided collums.

I have the solution for you put in your workbook.

Do you have questions, on this item, just ask.

In X5

=INDEX(May!J:J,MATCH($A5,May!$A:$A,0))

Then drag right to Y5 and fill down.

Or if the 'fineline' codes are always in exactly the same order with no new entries to the list or no old ones removed then just use

=May!J5


oeldere

INDIRECT() is best avoided when possible, especially when it's going to be copied to a large number of cells.

Let me know if you understand the formula.

Otherwise i can help you with that.

@jason.b75

INDIRECT() is best avoided when possible, especially when it's going to be copied to a large number of cells.

I completely agree with you. In the past I have offered the same advice and provided this link to go with it:

http://www.decisionmodels.com/calcsecretsi.htm

But I was accused of being arrogant for doing so.


@shanka

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

@jason.b75 # 8
@cutter #10

Both thank you for taking the time to point me on such an important issue. :thumb up:

@ Cutter the link you added is also usefull, also thank you for that.

I realy appreciate it.