lookup unique value in column A then display todays date eight columns across ??

Afternoon

i have a Spreadsheet where column A is filled with unique numeric ID's (these relate to forms i get sent up to my desk)

now when i get the form i do a search for the unique ID CTRL F and type in the number

once found i go to column G and type in todays date / =TODAY()

what i would like to do is on sheet 2 type in all the IDs at once (or 10 at a time) and then DATE them automatically

i will create a macro button but i cant work out the formula using MATCH / INDEX / VLOOKUP or IF in various combinations?????

lets say i type in the unique IDS in column Z on sheet 2 is there a way i can say
FIND Z1 in sheet1 column A and display =TODAY() 8 rows across
FIND Z2 in sheet1 column A and display =TODAY() 8 rows across
FIND Z3 in sheet1 column A and display =TODAY() 8 rows across


i thank you in advance as i know youll have a simple solution

mike

thankyou for the responses

let me just clarify though AH is not the destination cell as i do not want it 8 across from Z, i think i explained it a bit wonky so ill try again as i was massively hungover yesterday !!!!


i want to display the DATE 7 columns across (not rows sorry) from where the unique ID is found

the spreadsheet will be filled with thousands of rows of data pulled from forms that have been filled out across the business

the first column "A" will have a unique ID from the FORM and columns B,C,D,E,F,G will have various values in them (payees, amounts etc)

We have to date when they are recieved

instead of doing CTRL F to search for it and then type in the date i want to simply type in the unique ID (lets say in Z1 then Z2 3 4 5 6 7 8 9 & Z10) and the date to appear in column H of the row the unique ID is in

once i have the formula i will build a simple macro to keep the dates in there and clear the data entry cells (Z1 - Z10)


i will be using this formula for a few other projects aswell so your help is greatfully recieved

regards

mike