Formula Probs

M

Mike

I was kindly given this formula to use in my worksheet,
=IF(A2=1,L1,IF(A2=2,L2,IF(A2=3,L3,IF(A2=4,L4,IF(A2=5,L5,IF
(A2=6,L6,IF(A2=7,L7,IF(A2=8,L8,IF(A2=9,L9,""))))))))) but
it seems to error on the 9th it seems to be at the line
break
Any ideas anyone
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Array to Multiple Arrays 3
Picking up particular data from flat file 0
Formula Problem 2
Removing Sequential Numbers 5
Conditional format problem 19
Nesting IF/OR Statement 14
choosing column heading given a criteria? 6
HELP! change print order of mail merge labels from across to down 2

Top