x404.co.uk - View topic - Any Excel experts out there?

View unanswered posts | View active topics It is currently Sat May 31, 2025 7:07 pm

Any Excel experts out there?

Moderators: saspro, HeatherKay, belchingmatt, timark_uk, Blue_Nowhere, l3v1ck, veato

Page 1 of 1

[ 5 posts ]

Print view

Previous topic | Next topic

Any Excel experts out there?

Author

Message

tombolt

Spends far too much time on here

Joined: Fri Apr 24, 2009 8:38 am
Posts: 2967
Location: Dorchester, Dorset

Any Excel experts out there?

I am sure I've got this in the wrong place, though it's not specifically PC or Mac software. A friend has asked me to post the following:


	Quote: Please help I have to do something in excel but I have got stuck on something… I have 2 worksheets: Cells in worksheet 1 will contain numeric values. Cells in worksheet 2 will contain words. The words in worksheet 2 represent the values in worksheet 1. 1=poor 2=average 3=good 4=verygood 5=excellent So where cell A1 in worksheet 1 shows a value of 3, cell A1 in worksheet 2 will show a value of “good” I have tried using a SpellNumber function but I don’t think that is the right method… can anyone help?

I'm not sure that makes a lot of sense to me, as I don't really understand what his problem is exactly, but then I know virtually zero about excel!

_________________
I've finally invented something that works!

A Mac User.

Fri Jan 21, 2011 3:29 pm

jonlumb

Spends far too much time on here

Joined: Thu Apr 23, 2009 6:44 pm
Posts: 4141
Location: Exeter

Re: Any Excel experts out there?

I'd use a seperate little table and the vlookup function.

_________________
"The woman is a riddle inside a mystery wrapped in an enigma I've had sex with."

Fri Jan 21, 2011 3:31 pm

EddArmitage

I haven't seen my friends in so long

Joined: Thu Apr 23, 2009 9:40 pm
Posts: 5288
Location: ln -s /London ~

Re: Any Excel experts out there?

As Jon said I'd use a lookup table. If you want an example spreadsheet I can email it to you? Essentially you want a table somewhere (a separate worksheet?) with the number in one column, and the wording in the next (I'd call that region "Lookup" for clarity). If you have your first worksheet called "Numbers" and your second called "Words", then cell A1 in Words will contain the following:


	Code: =vlookup(Numbers!A1,Lookup,2)

HTH.

Edd

_________________


	timark_uk wrote: Gay sex is better than no sex


	timark_uk wrote: Edward Armitage is Awesome. Yes, that's right. Awesome with a A.

Fri Jan 21, 2011 3:38 pm

Fogmeister

I haven't seen my friends in so long

Joined: Thu Apr 23, 2009 7:35 pm
Posts: 6580
Location: Getting there

Re: Any Excel experts out there?

Yep, what these guys said...


	Code: Sheet 1... Cols... A 1 2 3 2 4 5 3 etc...


	Code: Sheet 3... Cols... A B 1 poor 2 average 3 good 4 very good 5 excellent


	Code: Sheet 2... Cols... A =VLOOKUP(Sheet1!A1,Sheet3!$A$1:B5,2,FALSE) =VLOOKUP(Sheet1!A2,Sheet3!$A$1:B5,2,FALSE) =VLOOKUP(Sheet1!A3,Sheet3!$A$1:B5,2,FALSE) etc...

Obviously, this depends on the exact locations of the data etc... but you should be able to work it out.

The formula in sheet 2 can go into any field but has to relate to the correct columns/rows in sheet 1 and 3.

_________________
Oliver Foggin - iPhone Dev


	JJW009 wrote: The count will go up until they stop counting. That's the way counting works.

Doodle Sub!
Game Of Life

Fri Jan 21, 2011 3:52 pm

tombolt

Spends far too much time on here

Joined: Fri Apr 24, 2009 8:38 am
Posts: 2967
Location: Dorchester, Dorset

Re: Any Excel experts out there?

Thanks guys, I've passed it on, appreciated.

_________________
I've finally invented something that works!

A Mac User.

Fri Jan 21, 2011 4:03 pm

Page 1 of 1

[ 5 posts ]

Who is online

Users browsing this forum: No registered users and 49 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum