ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Lookup or worksheet comparison (https://www.excelbanter.com/excel-worksheet-functions/175795-lookup-worksheet-comparison.html)

ComicFly

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


All times are GMT +1. The time now is 06:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com