All of them.

But the more data in the table, the longer excel will take to recalc.

=vlookup(a1,sheet2!a:b,2,false)

is fine.


Ross wrote:

Hi to all

I'm wondering how many rows (are they considered argument?) can be used for
a vlookup table?

Thanks
--
smither fan

--

Dave Peterson