On 2002-04-19 10:50, Noir wrote:
This formula works perfectly, it's just that it runs a little slow. Does anyone have any ideas on how to speed it up?
=VLOOKUP(A2,$A$1:$A$3000,1,FALSE)&" Found in row "&MATCH(A2,Sheet2!$A$1:Sheet2!$A$3000,0)
Thanks,
Noir
On 2002-04-19 11:01, Noir wrote:
Yes, sheets1&2 is 3000 rows deep. I am really using more rows than i need. I normally use closer to 1000 rows but, the other 2000 are there just in case.
On 2002-04-19 11:01, Noir wrote:
Yes, sheets1&2 is 3000 rows deep. I am really using more rows than i need. I normally use closer to 1000 rows but, the other 2000 are there just in case.