View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lee Crew Lee Crew is offline
external usenet poster
 
Posts: 10
Default Vlookup to an external file

I have a Vlookup in my workbook looing at a table in another workbook. It
works fine until what I'm looking for is more than 10082 lines down the
table, formula I'm using is:

=VLOOKUP($C3,[GBP_USER]Sheet1!$A$3:$I$65536,8,FALSE)

Does anyone know of a work around?