Previous Topic Next Topic

Excel dynamic matching

Closed
Onedevilsst Posts 1 Registration date Tuesday 20 October 2015 Status Member Last seen 20 October 2015 - 20 Oct 2015 à 07:48
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 20 Oct 2015 à 16:23
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 response

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
20 Oct 2015 à 16:23
i am confused. what you mean make it dynamic
also you said cell 1 but in formula you are using a3