henryhwong
New Member
- Joined
- Feb 25, 2014
- Messages
- 6
I have this:
First Cell =VLOOKUP(A12,'Acme'!A6:B$500,2,FALSE)
Second Cell =VLOOKUP(A13,'Acme'!A6:B$500,2,FALSE)
Third Cell =VLOOKUP(A14,'Acme'!A7:B$500,2,FALSE)
Fourth Cell =VLOOKUP(A15,'Acme'!A7:B$500,2,FALSE)
I'd like:
Fifth Cell = =VLOOKUP(A16,'Acme'!A8:B$500,2,FALSE)
Sixth Cell = =VLOOKUP(A17,'Acme'!A8:B$500,2,FALSE)
by just dragging on the corner of the box. I'm not sure how to do that?
I tried selecting the first 4 cells, hoping it would identify the trend, if it is was one cell at a time, no problem, but i'd like to drag this for hundreds of records and its not following the same structure.
Can someone please teach me how to drag and autofill correct to get the results i'm looking for? I also tried copy/pasting hoping those values would transfer ok, but that doesnt work either.
thank you!
First Cell =VLOOKUP(A12,'Acme'!A6:B$500,2,FALSE)
Second Cell =VLOOKUP(A13,'Acme'!A6:B$500,2,FALSE)
Third Cell =VLOOKUP(A14,'Acme'!A7:B$500,2,FALSE)
Fourth Cell =VLOOKUP(A15,'Acme'!A7:B$500,2,FALSE)
I'd like:
Fifth Cell = =VLOOKUP(A16,'Acme'!A8:B$500,2,FALSE)
Sixth Cell = =VLOOKUP(A17,'Acme'!A8:B$500,2,FALSE)
by just dragging on the corner of the box. I'm not sure how to do that?
I tried selecting the first 4 cells, hoping it would identify the trend, if it is was one cell at a time, no problem, but i'd like to drag this for hundreds of records and its not following the same structure.
Can someone please teach me how to drag and autofill correct to get the results i'm looking for? I also tried copy/pasting hoping those values would transfer ok, but that doesnt work either.
thank you!
Last edited: