Printable View
I am trying to complete a meal plan that uses 31 different entrees. I have column A numbered from 1 to 31. Column B has the name of the entrée.
I want to use an "=randbetween(1,31)" to pick out an entrée number, and print out the ACTUAL NAME in the next column.
Can that be done?
Thanks
In C1, type =RANDBETWEEN(1,31)
in D1, type =VLOOKUP(C1,$A$1:$B$31,2,FALSE)
Since you want to fix the menu for the whole month without duplicates, see the attachment
Outstanding, thanks, but I see that there are several duplications. Any way to stop that?Quote:
In C1, type =RANDBETWEEN(1,31)
in D1, type =VLOOKUP(C1,$A$1:$B$31,2,FALSE)
I'm sorry, but that makes no sense at all to me. Here is what I am seeing:Quote:
Since you want to fix the menu for the whole month without duplicates, see the attachment
Attached Files File Type: xlsb __monthly menu SNB.xlsb (14.7 KB, 3 views)
aa1 0.679587508 #NAME?
aa2 0.609065555 #NAME?
Am I supposed to put this in a particular place on the spreadsheet?
If you see #name it means:
- you use Excel <2010
I'm using Excel 2007Quote:
Originally Posted by snb
Yes, so did you check the attachment posted by snb for Excel 2007
Yep, just did, thanksQuote:
Originally Posted by Excel Fox