Hi all, I am new to this forum so forgive me if I get the terminology wrong.
I have created a formula for the IF function with 37 nested arguments, to look up the alphabetical price code (one for each letter A-Z of the alphabet A B C ...) in column G and return the price from the appropriate price reference in column O.
In one worksheet it works fine, but I have copied and pasted the formula to another sheet using the same cell positions as the first sheet and all I get is 'FALSE' unless the corresponding cell from column G is empty then a result is not returned (as in the first argument of the formula)
What am I missing ?
=IF(G5="","",IF(G5="A",$O$5,IF(G5="B",$O$6,IF(G5="C",$O$7,IF(G5="D",$O$8,IF(G5="E",$O$9,.... and so on
Thank you in advance
Bookmarks