Look data range

Learn Academy Feedback
,
1

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

1 Like
2

Hi @Girish26

Greetings…!

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

Regards :slight_smile:

3

Hi @Girish26

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

Cheers

4

@Raghavendraprasad
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
Girish
Harish
Suresh
Jagan

1 Like
5

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

6

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

1 Like
7

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

8

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

9

@Raghavendraprasad any idea like how to do lookup

10

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
11

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: