I have VLOOKUP working on full columns; 65535 rows in pre-2007 Excel.

160 items should not be a problem itself.
--
Gary''s Student - gsnu200761


"Larry" wrote:

I need help with an Excel spreadsheet. I have a workbook with two sheets.
Second sheet has 5 columns and 800 rows. Columns a
Customers Street City State ZIP Code

I need Excel to put the adress information relating to the customer (column
1) into 4 cells on the first sheet depending upon which customer is entered
into a cell on the first sheet.

I was able to get this to work except when I get below the 160th row no
information is pulled (N/A). Is there a record limitation?