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.

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.