How to drag “lookup data range” to entire column.
Can you please elaborate your question and post image if possible or the excel file
Buddy kindly have a look at this…
hope would help you
I’ve two columns in sheet 1(Name and Age) as shown Below.
In Sheet 2 i have to do Lookup datarange for entire Age Column with reference of sheet 1.
@Palaniyappan Not working as expected. I need entire age column to be filled automatically in sheet2
@Palaniyappan values are not getting printed in student1-copy excel
@Raghavendraprasad any idea like how to do lookup
Kindly elaborate on the requirement and provide us the input file (a sample atleast), we can surely get through this easier…
What he needs to do is write a macro and execute that macro. great solution @Palaniyappan I see he hasn’t elaborated the issue adequately.