Excel drag down formula not working good..

Z

zoola

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.
 
A

akphidelt

Put $ signs around any values you don't want to grow... so

D5:E15 becomes

$D$5:$E$15
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel drag down formula not working good.. 1
Dragging a formula down isn't working - where am I going wrong? 1
Trying to either hide data in a cell or reduce the data to zero 2
I need a different formula that can be copied down 2
Formula not working properly 2
dragging formula is giving me undesired result in cell calls. 0
Excel not correctly calculating formula 5
How can I make BINGO boards using EXCEL? 1

Top