J Jack Aug 4, 2003 #1 Is there a limit to the number of rows and/or columns that a lookup table can comprise? Thanks
J Jason Morin Aug 4, 2003 #2 You can make it as big as the worksheet - 65536 rows x 256 columns. I had no issues with this formula: =VLOOKUP(C20,Sheet2!1:65536,256,0) HTH Jason Atlanta, GA
You can make it as big as the worksheet - 65536 rows x 256 columns. I had no issues with this formula: =VLOOKUP(C20,Sheet2!1:65536,256,0) HTH Jason Atlanta, GA
