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!

Avathar77 · 27 Jul 2011 at 12:03

Sorry dont understand :confused:

Edit:
Do u need the formulas to get -
the figure of 27% of 1% in B13
the figure of 27% of 11% in B14
the figure of 89% of 45% in B15
the figure of 66% of 45% in B16 ????

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..

doogs · 27 Jul 2011 at 12:10

You will need a LOOKUP function. Sorry I don't have the time just now to help but it's not that difficult.

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

Paul. W · 27 Jul 2011 at 12:57

Here you go:

http://www.filefactory.com/file/cc93cd4/n/Copy_of_example.xls

Easiest way was to just change your table so instead of just having ranges, it included a cell for 0% to 100% with each corrosponding figure.

It means then I could do a stupidly simple VLOOKUP and you will get your percentages.

There is probably a way to do it with the ranges in your original table, but for the hassle requred to get the VLOOKUP working with that, theres no point.

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

Paul. W · 27 Jul 2011 at 13:41

Send me a message through trust and Ill email it over.

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

Paul. W · 27 Jul 2011 at 14:32

Not looked at your latest attachment, but im sure its fine

VLOOKUP formulas are very useful. Can also use them to chek for data duplication as well.

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!

fullmetaltony · 27 Jul 2011 at 15:38

Vlookups are great. Insert the vlookup formula into an =IF(ISERROR(*vlookup formula*),"",*vlookup formula*) to return blank cells instead of unsightly #NA errors. Much tidyer imho and quick to perform when you get used to it.