Formula

  • Thread starter Thread starter Tom
  • Start date Start date
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
 
Hi
use the following array formula (entered with CTRL+SHIFT+ENTER):
=INDEX(C1:C100,MATCH(1,(A1:A100="apple")*(B1:B100="orange"),0))
 
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...
 
You must log in or register to reply here.

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

Macro to add numbers in a text string 5
Index/match across multiple columns? 19
formula to count text entries and return text with most entries 8
Need help with IF Formula 4
Count the columns from one sheet and paste it in another sheet 0
Min-Max question 6
Find a value in table 2
Counting Subtotal 4

Back
Top