Look data range

How to drag “lookup data range” to entire column.

1 Like

Hi @Girish26


Can you please elaborate your question and post image if possible or the excel file

Regards :slight_smile:

Hi @Girish26

Buddy kindly have a look at this…
hope would help you


I’ve two columns in sheet 1(Name and Age) as shown Below.
Name Age
Girish 25
Harish 23
Suresh 22
Jagan 21

In Sheet 2 i have to do Lookup datarange for entire Age Column with reference of sheet 1.
Example: =VLOOKUP(A2,Sheet1!A:B,2,0)

Name Age

1 Like

Buddy @Girish26
here is your xaml buddy
lookup (2).zip (24.0 KB)

@Palaniyappan Not working as expected. I need entire age column to be filled automatically in sheet2

1 Like

alright here you go buddy @Girish26
lokup.zip (24.5 KB)
Kindly try this and let know buddy @Girish26

@Palaniyappan values are not getting printed in student1-copy excel

@Raghavendraprasad any idea like how to do lookup

Fine buddy
Kindly elaborate on the requirement and provide us the input file (a sample atleast), we can surely get through this easier…
no worries
Cheers @Girish26

1 Like

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. :slight_smile: