Lookup with offset

N

Nick_

I am returning a value from an array based on the lookup command, thi
works fine.
But I would like to step to another array of data depending on th
value in another cell.

I thought I may be able to incorporate the offset function in th
lookup function to do this but I am not having much luck.

Cheers
Nic
 
A

AlfD

Hi!

Can you post a bit of detail about your data - structure & location o
the 2 (?) tables; input & output of the lookup?

What formula are you using at the moment?

Al
 
Top