That worked, thanks alot!

"Domenic" wrote:

A little unclear, but assuming that B1, C1, D1, etc., contain the name,
try...

B2, copied down and across:

=INDEX(Apr!$AG$1:$AG$658,MATCH(B$1,Apr!$AG$1:$AG$6 58,0)+ROWS(B$2:B2))

Hope this helps!

In article ,
hcesc wrote:

I tried to figure out how I could get it to work for my situation but but was
unsuccessful.
This is what I have but it isn't working:
=INDEX(Apr!$AG$1:$AG$658,MATCH(B$1,Apr!$AG$1:$AG$6 58,0)-1)+(COLUMNS($AG1:AG1)*
4-4+1))

I am doing a Match to find the row number of the Name I am searching for
because they will not be in the same order in both sheets.

Once I find the name the data would be in the same order from sheet to sheet.