0

=IF((JANUARY!D6=K3),JANUARY!B6,"") This is the formula I'm using to try and pull information from the January tab, and place additional information on a different tab. This formula works, however, I need it to look for a specific value in two cells, and not just one. Basically, what I need the forumala to translate is, if the name Higgenbotham shows up on the January tab, in the cell D6 OR the cell E6,(not both at the same time), then I need the information from cell January tab, cell B6 to show up on the K1 tab in the C6 cell.

Improve this question
8
  • You mean something like: IF(XOR(JANUARY!D6="Higgenbotham", JANUARY!E6="Higgenbotham"),JANUARY!B6,"")?
    – cybernetic.nomad
    Jun 28, 2018 at 16:31
  • I believe that’s got it!! AWESOME! Thank you so much!!!
    – John Edwards
    Jun 28, 2018 at 16:48
  • Ok. Used the formula on my ipad version of excel and it worked fine. However, on my thinkpad, it is giving me a #Name? Error. I downloaded updates and add ones, but still getting the same error message. Any ideas?
    – John Edwards
    Jun 28, 2018 at 21:09
  • Being an old dinosaur who only uses desktops, I'm not sure. Maybe trying to use Evaluate (on the Formulas tab) to see where the problem is might help?
    – cybernetic.nomad
    Jun 28, 2018 at 21:32
  • Its underlining several things as I click across. I’ve tried everything, and still getting the same message.
    – John Edwards
    Jun 28, 2018 at 21:43

1 Answer 1

Reset to default
2

What's neede is an exclusive or (XOR):

=IF(XOR(JANUARY!D6="Higgenbotham", JANUARY!E6="Higgenbotham"),JANUARY!B6,"")

A XOR is essentially two ANDs wrapped in an OR

=IF(OR(AND(JANUARY!D6="Higgenbotham",JANUARY!E6<>"Higgenbotham"),AND(JANUARY!D6<>"Higgenbotham",JANUARY!E6="Higgenbotham")),JANUARY!B6,"")
Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .