IF:formula for 30+options

[Milkweed]

I'm trying to create a formula where I can insert a list of data just from entering a word or number. I'm using a "title" box to designate the info to be entered into another box. The problems is I have 30+ different lists that I potentially want in any one box. This is what I'm using but I'm limited in the number of lists I can potentially use. IF(D5=1,Data!C3,IF(D5=2,Data!C4))
Am I going about this all wrong, what can I do to fix this.

Thanks,

MW

 

[Domski]

Hi,

I reckon you should be able to use VLOOKUP like this:<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis...XH][/XH][/XR][/RANGE][/XH][/XR][/RANGE] Dom

 

[Milkweed]

Thanks, I'll give it a try.

 

[Peter_SSs]

Milkweed

Welcome to the MrExcel Board!

Your requirements are not completely clear to me, but you could see if this does what you want:

=INDIRECT("Data!C" & 2+D5)

 

[Milkweed]

Domski,
Thanks!! This is exactly what I was looking for. Sorry for being so novice at this, your a life saver.

MW

 

[Milkweed]

Peter,
Domski hit the nail on the head with that formula. What I'm trying to do is this. created a calendar on excel. I have 30+ data fields that I may need to input to a particular day. I numbered the data fields and wanted them posted on the individual day by just a single letter or number. So for day one if I want "A", just enter A in a cell and that list would pop up in that days cell. If I want list "F", then just enter F and that list would pop up for that day. I hope this explains it better.

MW