IF:formula for 30+options

M

Milkweed

New Member
Joined
Jun 2, 2008
Messages
4
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
 

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.
Sort by date Sort by votes
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
 
Upvote 0
Milkweed

Welcome to the MrExcel Board!

Your requirements are not completely clear to me, but you could see if this does what you want:
Code: 
=INDIRECT("Data!C" & 2+D5)
 
Upvote 0
Domski,
Thanks!! This is exactly what I was looking for. Sorry for being so novice at this, your a life saver.

MW
 
Upvote 0
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
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question Question
Modify a worksheet without registering it as a change
Replies
1
Views
124
Kaper
Kaper
H
  • Question Question
Using XLOOKUP in VBA to lookup value underneath specific header name (columns can change depending on worksheet)
Replies
0
Views
166
Hailee994
H
J
  • Question Question
Filtering Results in List Box
Replies
2
Views
139
JohnS_323
J
R
  • Solved
Setting up a test for students to get the right answer
Replies
9
Views
341
RodneyW
R
P
  • Question Question
How to create a multiple drop-down lists in Excel using Developer?
4 5 6
Replies
51
Views
1K
PetarTen
P

Forum statistics

Threads
1,224,804
Messages
6,181,061
Members
453,017
Latest member
rlundbulls23

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top