![]() |
![]() |
![]() |
|||||
![]() |
![]() |
![]() |
![]() |
![]() |
|||
| Welcome
to Tech Support Forum home to more then 136,000 problems solved. Issues
have included: Spyware, Malware, Virus Issues, Windows, Microsoft,
Linux, Networking, Security, Hardware, and Gaming Getting your
problem solved is as easy as: 1. Registering for a free account 2. Asking your question 3. Receiving an answer Registered members: * See fewer ads. * And much more..
|
| Want to know how to post a question? click here | Having problems with spyware and pop-ups? First Steps |
|
|||||||
| Microsoft Office support MS Office support forum |
![]() |
|
|
Thread Tools |
|
|
#1 (permalink) |
|
Registered User
Join Date: Jul 2008
Posts: 1
OS: Vista
|
Hi
I am currently creating a work book with several sheets (excel 2007), on 1 sheet i have a list of data on the second I am trying to pull a whole row of data by by entering a value in the first colum this works all ok using vlookup formula however i need to replicate the same formula down the page but when i do the table array part of the formula rolls on 1 each time it replicates =IF(C3="","",VLOOKUP(C3,Ingridients!A2:I203,9,FALSE)) =IF(C3="","",VLOOKUP(C3,Ingridients! A3:I204,9,FALSE)) If I only had a few to do i woulod change it manuall but i have about 400 rows to do each with 6 seperate cells. To complicate it further cell C3 does need to roll on i.e C3 - C4 -C5 ect on each replication. If anyone could help I would really appreciate it. N |
|
|
|
|
|
#2 (permalink) |
|
Registered User
Join Date: May 2008
Location: Baltimore, Maryland
Posts: 97
OS: Windows XP SP3
|
Re: Replicating Vlookup Formula
You can use the $ character to create absolute and mixed cell references in your formulas. If you enter your formula like this:
=IF($C3="","",VLOOKUP($C3,Ingridients!$A$2:$I$203,9,FALSE)) When you copy that cell to the cell directly below, the result is: =IF($C4="","",VLOOKUP($C4,Ingridients!$A$2:$I$203,9,FALSE)) Last edited by David M58 : 07-11-2008 at 07:37 AM. |
|
|
|
![]() |
| Thread Tools | |
|
|