collecting results from data tab - vllokup ?

[bumpty]

I am trying to match data on one tab to another so that the data downloaded from another source is sorted into a specific order for presentation perposes

I have tried using a vlookup but im not sure if that is the correct solution

ie on the attached I have a data tab that is a download of jobs by cost centre and this comes in from another source - on the results tab I am trying to pick up this data again to show in a specif order - I do not want to just point to the coresponding cell in the data tab as the real data is huge over 3000 lines each day
I want if possible to lookup the data in the data tab and post to the correct cell in the results tab

ie on the results tab C4 should return 25 jobs for the 1st March which it would read from the data sheet in volumn b6

appreciate any help with this i seem to be going round in circles and not confinced vlookup is the answer

thanks

[NBVC]

Do you mean, in C4?

=IF(ISNA(MATCH($A4,data!$A:$A,0)),"",VLOOKUP($A4,data!$A:$AG,COLUMNS($A$1:B$1),0))

copied down and across...

[6StringJazzer]

Will the dates in row 3 of "results" always be the same as the dates in row 4 of "data"? If so, then VLOOKUP is the best solution. You would use this formula in results!C4 and copy down and to the right as needed.

Please Login or Register  to view this content.

Didn't mean to step on NVBC's solution, I had this sitting open for a long time before I hit Submit and didn't preview first.