lookup in several cells

J

Jonsson

Hi all,

How to use lookup when having these conditions:

Formula in Sheet1:
Lookup(Sheet3 C4;Sheet2 B4,B8,B12;Sheet2 C5:C10,C15:C20

As you can see I need to lookup from several cellareas. The cell
between having text or are blank.

Any ideas are appreciated!

//Thoma
 
A

AlfD

Hi!

I would need more detail of precisely what was being looked up an
where and what the lookup table(s) consist(s) of.

Then detail needed on what to do with the results of the looking-u
(add them? concatenate them?...)

Al
 
Top