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?