none
A1=Cell (A2 & A3) RRS feed

  • Question

  • I am looking for a command that will allow me to display the data depending on formulas

    [A1] NEEDS TO DISPLAY DATA IN [B4] IF [A2] IS B AND [A3] IS 4.  

    Basically, I am looking for a way to have a cell equal another cell, but using a formula instead of just =B4.

    Tuesday, December 20, 2016 7:46 PM

Answers

  • Aha - perhaps

    =INDIRECT(A2&A3)


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by Mark Matzke Tuesday, December 20, 2016 9:40 PM
    Tuesday, December 20, 2016 9:37 PM

All replies

  • Does this do what you want?

    =IF(AND(A2="B",A3=4),B4,"")


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Tuesday, December 20, 2016 8:18 PM
  • Thanks, but no...  The cells A2 and A3 could be anything, and from those values, I want to display in A1 the corresponding coordinates.

     Note:  A major part of the confusion is that I don't know how to word this correctly, but this needs to be a fluid expression.
    Tuesday, December 20, 2016 8:31 PM
  • Aha - perhaps

    =INDIRECT(A2&A3)


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by Mark Matzke Tuesday, December 20, 2016 9:40 PM
    Tuesday, December 20, 2016 9:37 PM