Formula to find and fix data content

Ian Bell
Ian Bell used Ask the Experts™
on
Hi,
I would like a formula to locate certain data as per attached spreadsheet
Please use column 'D' for formula
Many thanks
Ian
Data-NR.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Use this in D5, copy down
=IF(ISERROR(SEARCH("(NR)",A5)),G5,1001)
Data-NR.xlsx
Ian Bellretired

Author

Commented:
Thanks Ejgil,

Works perfectly
Ian

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial