Lookup question

[NextByte]

G'day all,

Firstly have just this moment joined after hours of searching & learning from this site, congratulations to 1 & all that plays a part within this very site itself.

Office 2007
=======================
Colum A1
I need to be able to submit the following numbers & letter:
(0,1,2,3,4,5,6,7,8,9,x) & assign each number & letter a value which will be represented in A2

For example in this case I need to submit number 4 in A1
( its value in A2 needs to be 65.35 ) what or how do I do this? ie: sum etc etc

Any help on this matter would be greatly appreciated, apologies in advace if I have not worded this so it is easily understood.

Kind regards,
Chad(NextByte)

[oldchippy]

Hi Chad,

Welcome to the forum, you say you've spent hours searching the site. How about spending a little time reading this link and changing your question title?

http://www.excelforum.com/showthread.php?t=613916

Also we would need more examples of the numbers in column B i.e. what is the relationship between 4 and 65.35

[NextByte]

Hi Chippy,

Sorry mate, my bad! ( re: help )

Being able to enter specific numbers 0 - 9 & one letter (x) in A1 & have them represented in A2 is what I am trying to achieve.
The numbers to be entered in A1 each have their own ''Points system''
ie:
1= 21
2=15.5
3=11.45 etc etc

Does that help any Chippy ?

Thanks for answering anyway mate!

Cheers from Downunder.

Chad

[oldchippy]

Chad,

Still doesn't make sense mate. We need a little more.

Cheers from Upabove.

[NextByte]

Chippy,

Once again thanks for replying mate!

Ok here goes lol, get the bottle out folks
this could be a long winded one or just
another rambling.

The spreadsheet is for a rating system!

In colum A1 I need to submit either of the following:
0,1,2,3,4,5,6,7,8,9,x
The values of each number are as follows
0 = -21.00
x = -31.00
1 = 21.00
2 = 15.50
3 = 11.45
4 = 9.35

Lets say I enter 4 in A1, I need it to be represented in A2 as 9.35

Does this help any Chippy?

Regards,
Downunder

[EdMac]

Surely this is just a lookup function

Ed

[NextByte]

G'day Ed,

Thank you for the reply!
Sorry mate am a total NOOB

Am just researching the whole LookUp scenario now,
it is basically what I need I think!

Not sure, just want to be able to submit the numbers even,
1,2,3,4,5,6,7,8 in A1
and have them represented in A2 with corresponding values!

Thanks again for replying!
Regards,
Chad(NB)

[EdMac]

Hi Chad

select your value in A1 from a drop down of the possible values using data validation

then in A2

Please Login or Register  to view this content.

copy down as far as required

Ed

[NextByte]

Ed,

Thanks mate, hopefully this is the start of something! **a solution**

Say I enter 1 in A1 & its value to be represented in A2 should be 21 would the following be correct ?
=lookup(A1,{1=21})

regards,
Chad

[EdMac]

Nope!

Look at what I have written. I have taken the information from your earlier post. You need to have two sets of numbers, the second being the results you want and that needs to be plugged in where I have written "your values separated by commas".

Ed

[rkrause]

I'm new to excel, but i think i understand what he's saying...

=lookup(A1,{0,1,2,3,4,5,6,7,8,9,"x";your values separated by commas})


Your formula should look like this i think...

=lookup(A1,{0,1,2,3,4,5;-21.00,21.00,15.50,11.45,9.35}) or however you need your data to display with relation to the numbers


That makes sense to me, but like i said i'm new to this...

-Ryan

[EdMac]

Yep, Ryan's cracked it!

Ed

[NextByte]

G'day Ryan,

Thanks for trying to help mate!
Obviously I am doing something wrong ie:
when I enter into A2 =lookup(A1,{0,1,2,3,4,5;-21.00,21.00,15.50,11.45,9.35}) it comes back with the following error
'' The formula you typed contains an error''

Clearly I am doing something wrong, at the time of writing this I am reading the section ''Lookup & Reference'' hopefully I can understand where I keep stuffing up!

Thanks again.

Regards,
Chad

[Dean England]

Chad,

You've set six conditions, but only Five results. That's why your getting the error.

Dean

[NextByte]

G'day Dean,

I am sure someone is just sitting out there cacking themselves laughing at that one, how does Homer Simpson put it ''DOH''

Thanks for pointing me in the right direction, much appreciated!

Regards,
Chad

[oldchippy]

G'day Chad,

Glad to see you got the answer you needed - thanks for changing your title, now others may find this formula useful.

Cheers from Upabove

[Dean England]

Chad,

Nobody's cackling. We've all (well most of us) been there. Glad to have been some help. Good luck.

See ya,

Dean