Quote:
Originally Posted by Kevin@Radstock
Hi springs
This is similar to another post that I have just answered. See the attached file, see if that is something that you can work with.
In Cell B2 and copy down: =IFERROR(LOOKUP(20^20,SEARCH($D$2:$D$4,$A1),$D$2:$ D$4),"")
Replace the IFERROR if you have Excel 2003 < with IF & ISERROR.
|
Hi,
Thanks for this. This has solved my problems and everything is now working as it should for this.
Thanks again.