How to use a conditional to insert text into a cell based on a number (count) in a cell

[eoo]

Hi,

In my spreadsheet, I would like for a sentence (strings of text) from another worksheet to appear in a certain cell in another worksheet when a certain number is displayed. For example, If cell A1 shows 5, then I would like to have a function or formula to find the related '5' in the table with the text and print out the text found for the matching row into cell B1. I know that I can do this with a simple IF statement, but the problem is that the table with the text is 80 rows long already (and will probably grow a bit more) so that would be a lot of manual work and nested IF statements.

Is there a better way? Would this require VBA?

[FDibbins]

Hi, welcome to the forum

Have you tried using VLOOKUP() yet?

	A	B	C	D
1	2	bb	1	aa
2			2	bb
3			3	cc
4			4	dd
5			5	ee

B1=VLOOKUP(A1,$C$1:$D$5,2,0)

[Tony Valko]

Another option based on Ford's data table...

This formula entered in B1:

=INDEX(D1:D5,A1)

[eoo]

I am trying out the vlookup but I am getting the error message 'Value Not Available' error. Not really sure why as it is pretty straight forward equation. I am going to keep playing around with it.

Tony - I will try your method now as well. Perhaps it will work!

[FDibbins]

can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[eoo]

Actually I got the vlookup to work! My array was located on a different sheet but I didn't explicity say that in the formula (hence the error.) But it's now working great. Thank so much for your help!

[FDibbins]

Awesome

If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)