Formula

T

Tom

I have two columns I will like to create a formula that
will say if column one says apple and column two says
orange give me whats in column 3. Any Ideas?

Thanks in advance for your assistance.

Tom
 
F

Frank Kabel

Hi
use the following array formula (entered with CTRL+SHIFT+ENTER):
=INDEX(C1:C100,MATCH(1,(A1:A100="apple")*(B1:B100="orange"),0))
 
T

Tom

Thanks a million!

-----Original Message-----
Hi
use the following array formula (entered with CTRL+SHIFT+ENTER):
(B1:B100="orange"),0))

--
Regards
Frank Kabel
Frankfurt, Germany



.
Click to expand...
 
Top