This formula is working in 2 cells, but when I copy to a third cell it returns #N/A =IF(SEARCH("ALFA",C22),'QUOTE ENTRY'!$J$13,IF(SEARCH("ECKO",'QUOTE 25 LINES NO SUB'!C22),'QUOTE ENTRY'!$J$29,IF(SEARCH("DELTA-1",'QUOTE 25 LINES NO SUB'!C22),'QUOTE ENTRY'!$J$45,IF(SEARCH("DELTA-2",'QUOTE 25 LINES NO SUB'!C22),'QUOTE ENTRY'!$J$61,IF(SEARCH("V-STICK-S 300mm",'QUOTE 25 LINES NO SUB'!C22),'QUOTE ENTRY'!$I$7))))))
Solved by T. J. in 15 mins