I'm assuming that your data lists contain a zip code, a city name and a state
name in three columns. Let's assume that columns A, B, and C contain the
first 65,536 items of data and columns D, E, and F contain the remainder (so
you've effectively broken your data array into two separate arrays). Give
the first data list the range name "DataList1" and the second data list,
"DataList2". Let's say that you'll enter your zip code in cell G1. Your
lookup could be the following:

City:
=IF(ISNA(VLOOKUP(G1,DataList1,2,FALSE)),VLOOKUP(G1 ,DataList2,2,FALSE),VLOOKUP(G1,DataList1,2,FALSE))

State:
=IF(ISNA(VLOOKUP(G1,DataList1,3,FALSE)),VLOOKUP(G1 ,DataList2,3,FALSE),VLOOKUP(G1,DataList1,3,FALSE))

"Bartimus" wrote:

I am trying to perform a standard vector LOOKUP on some data I have. The
problem I am facing is that my data array contains over 83 thousand lines and
Excel will only work with 65536 lines. What am I supposed to do here? I
need the LOOKUP to work to replace city and state based on a zip code look up.