Resolved >>> IFTEXT usage?

[RicardoQueso]

Hello,

I have a sheet of addresses and have a column that indicates if I have shipped them something. I would like to populate the "shipped" column with an item name, then have excel pull the address onto a separate sheet if that column contains specific text. I tried the following formula:

=IF(ISTEXT(SEARCH("*CD",Sheet1!X2)),Sheet1!A2)

It currently is only returning FALSE even though X2 contains the word "CD". Is there a way to have Excel return a cell's data instead of a TRUE/FALSE?

Any help would be greatly appreciated, and please let me know if I need to provide additional details.

Thanks!

[shg]

See Help for SEARCH. It returns either a number or an error (#VALUE!), not text. You also don't need the wildcard character.

[RicardoQueso]

How would I get it to return the data in a cell rather than TRUE/FALSE?

[NBVC]

How would I get it to return the data in a cell rather than TRUE/FALSE?

You probably want:

=IF(ISNUMBER(SEARCH("CD",Sheet1!X2)),Sheet1!A2, "Not Found")

[RicardoQueso]

NBVC, you are a hero, that worked perfectly! You've saved me at least of couple of hours of cutting and pasting today, thanks so much!