Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel drag down formula not working good.. | Excel Worksheet Functions | |||
My good 'ol formula for inserting text isn't working!! | Excel Discussion (Misc queries) | |||
Macro lookup is not working good? | Excel Discussion (Misc queries) | |||
=%A%1, is this a good formula in Excel 2000? | Excel Discussion (Misc queries) | |||
click & drag not working | Excel Discussion (Misc queries) |