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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I use LOOKUP as the reference in OFFSET function? 5
looking up data in another worksheet 2
lookup options 2
Help needed 0
Lookup Function help 2
Return value greater than in LOOKUP 3
Screwy lookup function 2
wrapping offset around a lookup 7

Top