Excel Magic Trick 1016: Randomly Do A Two Way Lookup INDEX, VLOOKUP and RANDBETWEEN

preview_player
Показать описание

See how to randomly do a two way lookup:
1. INDEX and RANDBETWEEN
2. VLOOKUP and RANDBETWEEN
3. 5 ways to do Paste Special Values
  1. excelisfun
  2. Excel 2013
  3. Excel 2003
  4. Excel 2007
  5. Excel 2010
  6. excelisfun
Рекомендации по теме
Excel Magic Trick 0:04:03

Excel Magic Trick 1016: Randomly Do A Two Way Lookup INDEX, VLOOKUP and RANDBETWEEN

Excel Magic Trick 0:04:03

Excel Magic Trick 1016 Randomly Do A Two Way Lookup INDEX, VLOOKUP and RANDBETWEEN (nowtelugu.com)

Excel Magic Trick 0:05:55

Excel Magic Trick 1015: Counting With OR Criteria: SUMPRODUCT & COUNTIF Formula from pmsocho

Excel Magic Trick 0:09:55

Excel Magic Trick 1020: What Lens Do You Look Through When Solving Excel Problems

Excel Magic Trick 0:04:01

Excel Magic Trick 1019: Formula For Text Month Labels From Serial Date: EDATE, TEXT & COLUMNS

Choose A Random 0:02:40

Choose A Random Name From A List In Excel – Using RANDBETWEEN And VLOOKUP

Excel Magic Trick 0:23:26

Excel Magic Trick 1017: BMX State Point Calculation Worksheet: VLOOKUP and Data Validation List

Excel Magic Trick 0:04:28

Excel Magic Trick 1030: Round To The Nearest $50 For Pricing or To The Nearest Second For Times

Excel Magic Trick 0:04:28

Excel Magic Trick 1030 Round To The Nearest $50 For Pricing or To The Nearest Second For Times

How to Create 0:03:44

How to Create a Random Dataset in Excel Using XLOOKUP and RANDBETWEEN

Excel Magic Trick 0:11:36

Excel Magic Trick 997 Add Daily Sales with Text Day Criteria 3 or 4 Day Abbreviation Convention

Generate Random Non-Numeric 0:05:48

Generate Random Non-Numeric Values in Excel using RANDBETWEEN Function

Random selection (no 0:02:46

Random selection (no duplicates) from a list in Excel

RAND and RANDBETWEEN 0:10:17

RAND and RANDBETWEEN Functions in Excel

Excel Index and 0:04:43

Excel Index and RandBetween

Selecting random samples 0:10:04

Selecting random samples from a list using =randbetween() and =index(match()) in excel

Create Random Text 0:04:44

Create Random Text with CHOOSE in Excel

11 Amazing functions 0:10:15

11 Amazing functions like XLOOKUP, RANDARRAY, INDEX, CHOOSE, NORM.INV, EMONTH & RANDBETWEEN EMT ...

Vlookup Function to 0:03:33

Vlookup Function to Generate Random Names

Create Unique & 0:07:47

Create Unique & Random List Dependent Multiple Criteria from Database - Excel Formula Challenge!

Movie Picker in 0:00:16

Movie Picker in Excel using RANDBETWEEN and VLookup

Randbetween & VLookup 0:02:56

Randbetween & VLookup

Creating_a_unique_ID_using Excel's text 0:03:09

Creating_a_unique_ID_using Excel's text functions and randbetween()

Rand, Randbetween, Choose 0:10:55

Rand, Randbetween, Choose and If.

Комментарии
Автор

You are welcome! I probably should show some of the other formulas - I have some insane random data creating formulas...

excelisfun
Автор

Hi krn14242,

If you can use a helper column, maybe this is what you are looking for:
In a range A1:A10 insert =RAND()
In a range B1:B10 insert your teams

Now in any cell insert: =VLOOKUP(LARGE($A$2:$A$26, ROW(A1)), $A$2:$B$26, 2, 0)
and copy it down.

You can also search my channel for excel-211 if you want to download sample file for this or learn some polish :) :)

pmsocho
Автор

The only way i know is with VBA or Excel Add-in.

excelisfun
Автор

The formula above should be:
VLOOKUP(LARGE($A$1:$A$10, ROW(­A1)), $A$1:$B$10, 2, 0)
Sorry, but I copied it mistakenly from wrong data set example...

pmsocho
Автор

Thanks for the peek behind the curtain. Always curious how you get all your scenario data.

krn
Автор

Thanks... Learning Polish seems more difficult then Excel. :)

krn
Автор

Now, how can you create a list of unique names that are random? Say I wanted to randomly choose teams from a list of 10 names.

krn