Unique Random Numbers Using Formula

[papabill]

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

[alansidman]

In C1, type =RANDBETWEEN(1,31)
in D1, type =VLOOKUP(C1,$A$1:$B$31,2,FALSE)

[snb]

Since you want to fix the menu for the whole month without duplicates, see the attachment

[papabill]

In C1, type =RANDBETWEEN(1,31)
in D1, type =VLOOKUP(C1,$A$1:$B$31,2,FALSE)

Outstanding, thanks, but I see that there are several duplications. Any way to stop that?

[papabill]

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)

I'm sorry, but that makes no sense at all to me. Here is what I am seeing:

aa1 0.679587508 #NAME?
aa2 0.609065555 #NAME?

Am I supposed to put this in a particular place on the spreadsheet?

[snb]

If you see #name it means:

- you use Excel <2010

[papabill]

If you see #name it means:

- you use Excel <2010

I'm using Excel 2007

[Excel Fox]

Yes, so did you check the attachment posted by snb for Excel 2007

[papabill]

Yes, so did you check the attachment posted by snb for Excel 2007

Yep, just did, thanks