Hello everyone,
i am in need of some help to optimize a formula.
In worksheet "GL-EXIT DOOR - ARENA Plaza" in cell D14, i am looking to optimize it.
at the moment the formula takes the content in C 15 and compares it with "Lookup Table " worksheet in Position and places content of C3.
if any of the key words are not found then the default value is assigned.
is there anything that can be done to make the formula cleaner?
Thank you for any assistance.
In D21 then copy down.
Similarly make suitable change and use for other columns.
Please Login or Register to view this content.
Last edited by kvsrinivasamurthy; 08-21-2019 at 07:41 AM.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Please try at D14
=INDEX('Lookup Tables'!$C$3:$C$8,MATCH(1,--(SEARCH({"Zone";"Manager";"Control";"Supervisor";"@";""},C21)>0),))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks