Number value in one cell will equal a text value in another

[Geoffo123]

Hi,
Not sure how to do this, but I have one cell who's number value is taken from a drop-down list.

I need a corresponding cell to equal a text value depending upon the number chosen.
Can somebody please let me know how to do this

Thank you in advance

 

[JLGWhiz]

Not sure exactly what you mean, but you can force numbers which are in cells as text to become integers by using the conversion functions.
CInt(Range("A1").Value) turns a text value in cell A1 to an integer value.
CLng(Range("A1").Value) turns it to a Long Integer value
CDbl(Range("A1").Value) turns it to a Double Iteger value for currency and other decimal values.

 

[Eric W]

Welcome to the forum.

Are you talking about some kind of a look-up function?

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Number[/TD]
[TD]Matching Text[/TD]
[TD][/TD]
[TD]Number[/TD]
[TD]Text[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Horrible[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]Horrible[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Yucky[/TD]
[TD][/TD]
[TD]2[/TD]
[TD]Terrible[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Pretty Good[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]Bad[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]4[/TD]
[TD]Yucky[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]5[/TD]
[TD]So-So[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]6[/TD]
[TD]OK[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]7[/TD]
[TD]Pretty Good[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]8[/TD]
[TD]Great[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]9[/TD]
[TD]Fantastic[/TD]
[/TR]
</tbody>[/TABLE]

The formula in B2 is:

=VLOOKUP(A2,$D$2:$E$10,2)


There are other types of lookups too.

 

[Geoffo123]

All good guys, thank you for the response

 

[JLGWhiz]

All good guys, thank you for the response

Happy to assist,
regards, JLG