Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to take this formula and move it from on column to another and
only change one value. When I go to edit the formula it removes the "{}" around the formula. The formula works in the original cells but If I add the "{}" it will not caluculate. {=IF(ISERROR(INDEX($T$1:$W$2500,SMALL(IF($T$1:$T$2 500=$A3,ROW($T$1:$T$2500)),ROW($8:$8)),4)),"",(IND EX($T$1:$W$2500,SMALL(IF($T$1:$T$2500=$A3,ROW($T$1 :$T$2500)),ROW($8:$8)),4)))} I just want to change row 8:8 to row 9:9 and so on. If I edit the original cell it changes the formula to remove the "{}" and the formula will no longer pull the data. Please help with how to correct this issue. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need help with INDEX lookup | Excel Worksheet Functions | |||
Lookup? Index? or something else? | Excel Discussion (Misc queries) | |||
How to stop index match returning data where lookup cell empty | Excel Worksheet Functions | |||
Either LOOKUP or INDEX Help | Excel Worksheet Functions | |||
Only text values matching using index/match lookup - data type pro | Excel Worksheet Functions |