If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel drag down formula not working good..
hi,
i have a formula =IF(E6="Casual",VLOOKUP('Product Detail'!L6,Types!D4:E14,2,0),IF(E6="Dress",VLOOKUP ('Product Detail'!L6,Types!A4:B12,2,0))) when i drag it down to the rest of the cells i want only E6 to become E7 and grow each time i drag the formula down. the problem is when i drag the formula down it becomes like this: =IF(E7="Casual",VLOOKUP('Product Detail'!L7,Types!D5:E15,2,0),IF(E7="Dress",VLOOKUP ('Product Detail'!L7,Types!A5:B13,2,0))) everything grew by 1 number. i tried putting $ signs before each letter but its not working for some reason. can someone find a problem here in my fomula or excel, am i doing something wrong? thanks for your time. |
#2
|
|||
|
|||
Excel drag down formula not working good..
If you are dragging down and the numbers are growing, then you need to put
the $ sign before the *number*. Putting the dollar sign before the *letter* will stop that growing when you drag across. Look up absolute and relative addressing in Excel help. -- David Biddulph zoola ander wrote in message ... hi, i have a formula =IF(E6="Casual",VLOOKUP('Product Detail'!L6,Types!D4:E14,2,0),IF(E6="Dress",VLOOKUP ('Product Detail'!L6,Types!A4:B12,2,0))) when i drag it down to the rest of the cells i want only E6 to become E7 and grow each time i drag the formula down. the problem is when i drag the formula down it becomes like this: =IF(E7="Casual",VLOOKUP('Product Detail'!L7,Types!D5:E15,2,0),IF(E7="Dress",VLOOKUP ('Product Detail'!L7,Types!A5:B13,2,0))) everything grew by 1 number. i tried putting $ signs before each letter but its not working for some reason. can someone find a problem here in my fomula or excel, am i doing something wrong? thanks for your time. |
Thread Tools | |
Display Modes | |
|
|