Moving data when a match is found on a different Tab.

Hi

I have 2 sheets 'REPORT & TRACKER', what i'm trying to do is this, In COL A of tracker is a reference number, i need to find this number in Report and once it is fouond then the data from cells M,H & I need to be moved over into B,C & D in the Tracker tab.

I've attached a example

Thanks in advance

You can use Vlookups to accomplish this.
In column B of the Tracker sheet, copy down:

Please Login or Register  to view this content.

In column C of the Tracker sheet, copy down:

Please Login or Register  to view this content.

and in column D of the Tracker sheet, copy down:

Please Login or Register  to view this content.

Obviously the A5 in the formulas should reference column A of the current row.
You can check out the help file on VLookups for details, if needed.

The length shouldn't matter; you can make it C3 to T999 as long as your data never has more than 999 lines. Did the formulas work in your sample sheet for you? They worked for me. If you click on the formula button after typing the entire formula in, it will give the result from each argument. Which argument is causing it to fail?

The data you are trying to match with on the Report tab is in column C. In your larger example, you changed the Vlookup argument to look at column A. If you change this:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

it works.