Assign text to cells

**Squig** · 12-13-2011, 04:27 AM

Since I'm a good way through this project I hope that someone with greater expertise can solve this latest problem:

I want to assign a range of possible texts to a cell - potentially about 100 - such that when the user places a 1 in cell A1 the first statement appears alongside in A2, when a 3 is placed in A1 the third statement appears in A2, etc. My initial thought of nesting IF statements is both unwieldy and impossible. Hopefully someone can advise.

Thank you

**arthurbr** · 12-13-2011, 04:33 AM

Hi and welcome to the board
If you build a table with numbering from 1 to ... in the first column and the statemenst in the second ( say range E1:F100), you can retrieve the statements with =Vlookup(A1,$E$1:$F$100,2,false) and pull down as necessary

Adapt the ranges to your needs

**Squig** · 12-13-2011, 04:38 AM

Thanks Arthur

Will this take approx 100 statements?

**arthurbr** · 12-13-2011, 04:39 AM

What do you mean ? How many statements do you have?

**Squig** · 12-13-2011, 05:03 AM

Currently about 60 -70!

**Squig** · 12-13-2011, 06:17 AM

Hi Arthur

A bit of tweaking for my personal circumstances and it seems to be working perfectly! The next part is going to take me an age to input but should save hundreds of hours in the long term. Thanks for your help!

**arthurbr** · 12-13-2011, 06:52 AM

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save