View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Lookup of sorts...Matrix Array etc.

Hi Michele
not sure if you already got to the solution by yourself :-)
try
=vlookup(j2,A1:F21,1+j1,False)

Frank



Michele wrote:
This works but doesnt take into account the J1 input, that would
effevtively offset the look up by that value. Thanks!