Formula Help

[TWeaver565]

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

[#2]

@TWeaver565 

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.