Hi,
I am going round and round but not getting the results I am after.

I have 2 worksheets. Worksheet 1 contains a list of reference numbers, and names. Worksheet 2 contains a list of invoices along with reference numbers. The reference numbers are the common link between the 2 sheets.

On the 2nd worksheet I have a column and I need it to be populated by the correct name from worksheet 1. I need it to search worksheet 1 for the same reference number and when it does copy the value of the name cell on the same row to sheet 2.

eg:
Sheet 1

A B
1234 John Smith
1292 Tom Jones
1254 Bill Smith
1341 A. Nother

On worksheet 2:
A B
100.00 1341
19.99 1292
27.14 1254

Hope this makes sense.

Thanks

Matt