Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
Apple Computing Products:
macOS - Apps and Programs
VLOOKUP with RANDBETWEEN function for MAC Excel 2008
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Brevardo" data-source="post: 1841583" data-attributes="member: 403880"><p>I am trying to create a workbook using Mac 2008 Excel. I want to use a VLOOKUP function and I'm not real sure how to do it. Currently I have workbook where in Cell E4 I have a formula =RANDBETWEEN(10,50)</p><p>so every time I refresh the excel workbook the number that displays will be 29 and then if I refresh the sheet again it will show another arbitrary number such as 34 or 49. This part is working exactly how I designed. However, I would like to somehow use VLOOUP with this with corresponding table. So that way instead of the cell E4 showing the number 29 it will show text from a VLOOKUP Table that would say something like "2 points by A10 or 3 points by A24. Let me know if you can lead me in the right direction as I can post a screenshot of the excel sheet I have designed so far. Thanks, Rich H</p></blockquote><p></p>
[QUOTE="Brevardo, post: 1841583, member: 403880"] I am trying to create a workbook using Mac 2008 Excel. I want to use a VLOOKUP function and I'm not real sure how to do it. Currently I have workbook where in Cell E4 I have a formula =RANDBETWEEN(10,50) so every time I refresh the excel workbook the number that displays will be 29 and then if I refresh the sheet again it will show another arbitrary number such as 34 or 49. This part is working exactly how I designed. However, I would like to somehow use VLOOUP with this with corresponding table. So that way instead of the cell E4 showing the number 29 it will show text from a VLOOKUP Table that would say something like "2 points by A10 or 3 points by A24. Let me know if you can lead me in the right direction as I can post a screenshot of the excel sheet I have designed so far. Thanks, Rich H [/QUOTE]
Verification
Post reply
Forums
Apple Computing Products:
macOS - Apps and Programs
VLOOKUP with RANDBETWEEN function for MAC Excel 2008
Top