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?

Number	Matching Text		Number	Text
1	Horrible		1	Horrible
4	Yucky		2	Terrible
7	Pretty Good		3	Bad
			4	Yucky
			5	So-So
			6	OK
			7	Pretty Good
			8	Great
			9	Fantastic

<tbody>
</tbody>

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