Help with formula

[mIKE]

I am trying to select info from another sheet depending
what number i add in a column, see formula
=IF(A1=3,A19)+IF(A1=4,A20) have more to addd but want to
get it working first, it works fine with numbers but if i
add text it goes to an error #VALUE, any ideas anyomne or
can you think of a different way of doing it

Mike

 

[J.E. McGimpsey]

If your pattern continues, you might try something like:

=SUM(OFFSET(A19,,,A1-2,1))

or, setting bounds:

=IF(AND(A1>0, A1<20), OFFSET(A19,,,A1-2,1)),"Not Valid")


This won't error if A19:An has text since SUM ignores text.