Formula Help

Copper Contributor

On sheet1 in A7 i want to search sheet2 and display the text in A2:B2 but only if I2 contains "Send"

1 Reply



Let's see if this works.




with the difference being that the latter concatenates the contents of A2 and B2


If those somehow don't fit with your actual circumstances, perhaps you could attach a copy of your spreadsheet. I had to replicate as best I could from your description.