How do I move a nested formula to another cell?

[A440]

Hi, I have the following formula in B1, all I need to do is insert 2 blank rows above but when I insert them I can't get the formula to work again.
Does a nested formula have to be in row 1:1?

'=IF(ISERROR(INDEX($C$1:$D$119,SMALL(IF($C$1:$C$119=A1,ROW($C$1:$C$119)),ROW($1:$1)),2)),"",INDEX($C$1:$D$119,SMALL(IF($C$1:$C$119=A1,ROW($C$1:$C$119)),ROW($1:$1)),2))

Any help would be greatly appreciated. Thank you.

[Tony Valko]

It looks like you can use a much more efficient VLOOKUP formula.

=IFERROR(VLOOKUP(A1,C:D,2,0),"")

[A440]

Talk about over working something!! Thank you
"Keep It Simple Stupid" Lol.

[Tony Valko]

You're welcome. Thanks for the feedback!


If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.