Whether it will make a difference or not, I can't say, but you have left
out the fourth parameter of VLOOKUP.
Help is misleading on the question. For a list sorted in ascending
order, such as you have, Help suggests the fourth parameter TRUE (1).
If you specify FALSE (0), VLOOKUP makes an exact match. That may make a
difference to your results.
If you want a different result, use SHIFT+CTRL+F9 to force a
recalculation. (You may find that without the fourth parameter,
recalculation causes an error.)
Andy Chaplin wrote:
Hi there Everyone
I have a problem with the calc formula RANDBETWEEN.
I have created a numbered list from 1 to 100 in column A. In column B is a
list of questions I want to select.
In another sheet I have used VLOOKUP and RANDBETWEEN in 10 sucessive rows to select 10 random items from the list. So far so good. The problem is that RANDBETWEEN allow duplicates (and I must say, they appear unusually frequently!).
The formula I used was:
=VLOOKUP(RANDBETWEEN(1;100);'other_sheet'.$A$6:$C$105;2)
Is it possible to select from a list randomly but without duplicates?
Any suggestions would be appreciated.
--
If you're seeking, check out http://www.rci.org.au
Send instant messages to your online friends http://au.messenger.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
