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.

  • You mean something like: IF(XOR(JANUARY!D6="Higgenbotham", JANUARY!E6="Higgenbotham"),JANUARY!B6,"")? – cybernetic.nomad Jun 28 '18 at 16:31
  • I believe that’s got it!! AWESOME! Thank you so much!!! – John Edwards Jun 28 '18 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 '18 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 '18 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 '18 at 21:43
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,"")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.