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!
|