VBA LookUp date

[tiger01]

Hi

I have two worksheets. In "worksheet 1" I have a date formatted MMM-YY in column A and in column B I have a number.
In the "worksheet 2" I have MMM-YY column headings.
What I need is excel to lookup the date in worksheet 1 and return the number thats in column B under the corresponding MMM-YY column in worksheet 2. So, for examle;

Worksheet 1
Column A Column B
OCT-12 5

Worksheet 2
SEPT-12 OCT-12 NOV-12
5

Thanks in advance
Jen

[galvinpaddy]

Hi, how many dates will be entered into sheet2?
Its often easier for you to post a sample workbook, with the expected result and some notes to explain.

Otherwise anyone who tires to help has to guess what you want

[galvinpaddy]

Hi again,

Does the atatched help?
sheet one has the raw data (column A = dates, Column B = number)
Sheet 2 column A is where you manually type a date and then click the macro button.

[kvsrinivasamurthy]

Pl see the attached file with Formulas.You can drag to right.

[tiger01]

Excel Test.xlsx

Hi Both
Thanks for your replies.

GP - sorry I couldnt get your macro to work as it was asking me to open as read only???
KV - I couldnt get your formula to work in my spreadsheet.

Ive attached a copy of what I am trying to do with notes. Appreciate your help.
Cheers

Jen

[Norie]

Jen

Try this in H1 and copy across and down.

Please Login or Register  to view this content.

[tiger01]

Thanks Norie! Works Perfectly.
Jen

[galvinpaddy]

Hi, save mine to your desktop first :-)