Sep 09 2021 10:07 AM
On sheet1 in A7 i want to search sheet2 and display the text in A2:B2 but only if I2 contains "Send"
Sep 09 2021 12:04 PM
Let's see if this works.
=IF(Sheet2!I2="Send",Sheet2!A2:B2,"")
or
=IF(Sheet2!I2="Send",Sheet2!A2&Sheet2!B2,"")
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.