View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
N Harkawat N Harkawat is offline
external usenet poster
 
Posts: 55
Default Lookup, one row down

=index(a1:a1000,match(a1,b1:b1000,0)+1)

"Tomas Stroem" wrote:

Hi,

I have a large database in an Excel file containing order information.
I need to match delivery times from this database with some estimated
production times per order number. In some cases there are two delivery times
but the order number in the databsae is the same.
Does anyone have an idea on how to also get the other delivery time, which
always is found on the row under the first desired row.

Kind of Vlookup(a1;Range;Row;0)+1
--
Tomas S