Excel dynamic matching

Closed
Onedevilsst
Posts
1
Registration date
Tuesday October 20, 2015
Status
Member
Last seen
October 20, 2015
- Oct 20, 2015 at 07:48 AM
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
- Oct 20, 2015 at 04:23 PM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
768
Oct 20, 2015 at 04:23 PM
i am confused. what you mean make it dynamic
also you said cell 1 but in formula you are using a3
0