C
ComicFly
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
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