Hi all :-)
I'm having an issue with following formula. Currently is working, however range 'Server List'!$D$2:$D$1045 is changing on regular basis.
I want to avoid manual update and to highlight whole column is not working. No results.
=IFERROR(LOOKUP(2^15,SEARCH('Server List'!$D$2:$D$1045,MSL!B2),'Server List'!$D$2:$D$1045),"No Match")
Can anybody help with this?
Thanks :-)
Bookmarks