finding data in the same sheet

  • Thread starter Thread starter Barry
  • Start date Start date
B

Barry

Hi, I wonder if any one can help I have a work sheet where in A4 down to A40,
I type in a list of names, B4 to Y4 down to B40 and Y40 contains data with an
average in Z4to Z40. In AP4 down to AP 60 I have another list of names.
What I would like to do is: - say AP4 Has the name John Doe in it, I would
like to look in A4 to A40 find John Doe and copy the figure in Z4 to Z40 so
if John Doe is in A5 then copy the data from Z5 and paste it into AQ4.
I would then like to make 28 copies of the sheet in the workbook.
Thank you in advance to any one who has a go at this.
Barry.
 
Put this formula in AQ4:

=IF(ISNA(MATCH(AP4,A$4:A$40,0)),"",VLOOKUP(AP4,A$4:Z$40,26,0))

then copy down to AQ60.

As for copying sheets, I find the quickest way is to do a CTRL-drag on
the sheet tab to create an exact copy - just do this another 27
times !!

Hope this helps.

Pete
 
Back
Top