![]() |
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