| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup or worksheet comparison
I have 2 worksheets with 700 and 1000 lines. Is there a formula I can use to
look up cell data from one worksheet to another on a Random basis. In other words, I want to audit 60 cells on a random basis in one worksheet by looking up that data in the other worksheet. I tried "vlookup(Randbetween(1, 500),........) but it does not work. thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup data based on data comparison | Excel Worksheet Functions | |||
| bringing data together from two worksheet for comparison | Excel Worksheet Functions | |||
| Excel worksheet comparison software | Excel Worksheet Functions | |||
| Lookup and summing comparison | Excel Worksheet Functions | |||
| How do I lookup data with two comparison values? | Excel Worksheet Functions | |||
Linear Mode
