Excel help

BenJ · 27 Jul 2011 at 11:51

Could anyone tell me the formula I need in cells C13-C20 to return the figure from the table based on the data in cells B13-B20?

I've just knocked up an example in excel, see here..
http://www.filefactory.com/file/cc92910/n/example.xls

Thanks!

BenJ · 27 Jul 2011 at 12:09

oh no calcs need to be made, the data in cells C3-C9 simply needs to be returned in cells C13-C20, based on the info in cell B13-B20. You could imagine the figures in C3-C9 are merely words or numbers rather than percentages..

BenJ · 27 Jul 2011 at 12:23

I have got it to work by this, but I just feel its a really long way of getting to where I want. If only I knew how to enter the info in cells B3-B9 so that excel recognises its a range between the first and last number.

The way I have it at the moment means to change the ranges I have to alter the info in column G and then the names in col b in table 1. Bit tedious to maintain. I'd simply like to change the info in col b in table 1 and be done with it if possible!!???

http://www.filefactory.com/file/cc93a59/n/example.xls

BenJ · 27 Jul 2011 at 13:35

arghh wont let me download from there >< says my ip has exceeded number of free downloads, must be somthing to do with work

BenJ · 27 Jul 2011 at 14:05

cheers, have sent mail

BenJ · 27 Jul 2011 at 14:08

actually after looking through excel help I seem to have cracked it with one simple formula. Whoever mentioned lookups was correct!

http://www.filefactory.com/file/cc93f5c/n/example.xls

solution above.

I've only used vlookups and didn't even realise you could do this with lookups, lesson learnt for the day

BenJ · 27 Jul 2011 at 15:14

yea vlookups i use all day everyday with work, its the "lookup" function I was not familiar with!