Macro for matching between two spreadsheets and finding a value

[someoneelse84]

Hey people.

I've been given a terribly daunting task and just know that a macro can save my day.

I have two spreadsheets, spreadsheet A and B. In each spreadsheet there is a column labeled 'event' and a number in that column. I need to match the event number in spreadsheet A with the same number in spreadsheet B. In spreadsheet B in the same row as the event number is another value that I need copied back to spreadsheet A.

Manually I would have to copy the event number from spreadsheet A and use 'find' in spreadsheet B. Then check in the same row as the event number in spreadsheet B for a specific number, copy that, head back to spreadsheet A and paste it next to the event number.

I've tried to create a macro to do this but when using 'find' to match the event number in spreadsheet B it keeps on using the first event number I used instead of moving down a row onto the next number.

I can upload the spreadsheet if needed.

Please help

ps: This isn't easy to explain for me, so if I can clarify my problem in any way please let me know.

EDIT: Added both spreadsheets, can explain more thouroughly now.

I need to match the value of 'event number' in spreadsheet A (columb B) with the 'event number' in spreadsheet B (column A). I then need to get the value under column U in spreadsheet B and copy it to spreadsheet A column A.

Please forgive my noobness at excel

[rylo]

Hi

You can use the VLOOKUP function to do this. In A2 enter the formula

Please Login or Register  to view this content.

, update to reflect the proper spreadsheet names, then copy down. Will fill as required.

HTH

rylo

[someoneelse84]

Thank you very, very much rylo!