Hi Guys,
What I'm trying to do is, to search for column "K" values in the array of column "E", and produce the based in column "F". However, if the value in column "F" is "ACTIVE", I would then want to produce the result in column "G" instead. If the value is not found in column "E", it will then produce a result of "CHECK".
Please assist.
Last edited by Zach8384; 10-13-2012 at 01:04 AM. Reason: Wrong Title, Does not comply with forum rule
hi Zach8384, copy this formula & paste inside the formula bar:
then press CTRL + SHIFT + ENTER to confirm
Please Login or Register to view this content.
Last edited by benishiryo; 10-13-2012 at 12:40 AM. Reason: add file
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
hi benishiryo,
it doest not get what i want, for example, "177358001" is found in "60177358001" so it sould return "50" instead of check
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks