Excel dynamic matching

Closed
Report
Posts
1
Registration date
Tuesday October 20, 2015
Status
Member
Last seen
October 20, 2015
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
hiya,

i have three sheets:

sheet 1 - detail is input manually someone's name and personal details

sheet 2 - a sheet that takes some detail from sheet 1, and will be populated live from the next sheet.

sheet 3 - is contained in a template 'blank' folder full of all the forms and files we need for every customer. once sheet 1 is completed, this template, copied and renamed as per cell 1 in sheet 1.

how do i make sheet 2 vlookup the relevant detail? in particular how it can use the detail in cell 1, sheet 1, to look in the usual location for the right worksheet?

=vlookup($a$3, 'c:\users\desktop\newhire\ ****"name in cell"****!A1:F7,4,false)
i cn seem to get the address in the vlookup to become dynamic, and its doing my head in.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
i am confused. what you mean make it dynamic
also you said cell 1 but in formula you are using a3
0