Help!
must doing something very stupid, but cant work out what it is!
i get the follwing error. screen shot and xls attached.
can anyone help?
Many thanks
Help!
must doing something very stupid, but cant work out what it is!
i get the follwing error. screen shot and xls attached.
can anyone help?
Many thanks
Check out my photography site, Lens Art http://www.lensart.me.uk
Hi,
You have an error in the named range Step1Select. It currently reads
=OFFSET(INDIRECT(ADDRESS(MATCH(Step1Cell,Step2List,0)+1,5,,,"Lists")),0,0,COUNTIF(Step2List,Step1Celll),1)
where I think it should read
=OFFSET(INDIRECT(ADDRESS(MATCH(Step1Cell,Step2List,0)+1,5,,,"Lists")),0,0,COUNTIF(Step2List,Step1Cell),1)
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
genius!
in actual fact it should have been "Step1Cell", and not "Step1Cel l" but the truth of matter is i made a typo and couldnt see the trees for the forrest!
thanks very much mate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks