Dav Wrote:
No is the short answer, you can combine 2 cells to overcome the problem
but what are you wanting to do anyway
It seems that a lookup or a simple formula could work instead and you
would not need the multiple ifs. You may need to put the formula inside
an if statement to stop it going out of range or if whole numbers do not
appear
but basically you are saying
=OFFSET(A3,0,S1)
or
=if(and(s1=1,s1<=8,trunc(s1)=s1),OFFSET(A3,0,S1), 0)
excludes none whole numbers and allows numbers between 1 and 8
Regards
Dav
Thanks Dav,
I decided to use offset and it works well.Basically I got drop down
menu format which link to cell s1.
Cheers
--
wan
------------------------------------------------------------------------
wan's Profile:
http://www.excelforum.com/member.php...o&userid=37523
View this thread:
http://www.excelforum.com/showthread...hreadid=571675