Autofill up lookup value

Sheet 1

A B

1 Apple 10

2 Pear 8

3 Orange 3

 

Sheet 2

A B

1 Apple 7

2 Orange 3

3 Durain 1

 

Sheet 3

A B

1 Orange 4

2 Pear 6

3 Banana 5

 

Sheet 4

A B

1 =VLOOKUP(A1,Sheet1!A:B,2,FALSE)

2 =VLOOKUP(A2,Sheet1!A:B,2,FALSE)

3 =VLOOKUP(A3,Sheet1!A:B,2,FALSE)

4 =VLOOKUP(A4,Sheet1!A:B,2,FALSE)

5 =VLOOKUP(A5,Sheet1!A:B,2,FALSE)

6 =VLOOKUP(A6,Sheet1!A:B,2,FALSE)

 

Data will be input manually in Sheet 1, Sheet 2 and Sheet 3

How do I auto fill in on Sheet 4 when I only enter in Sheet 1, Sheet 2 and Sheet 3

Sheet 1, Sheet 2 and Sheet 3 might have the same lookup value.

By: Hock Seng

Leave a Reply

Your email address will not be published. Required fields are marked *