Hi,
I would like to determine the word selected from listing.
Question : If name below have action type with word "confirm" from listing below, answer show is Yes.If not, answer is flase
Name Answer
AA
BB
CCC
DD
EE
FF
LISTING
Name Action Type
AA Conversion w confirm.
AA Transfer
BB Promotion
BB Conversion w confirm.
BB Promotion
CCC Confirmation
CCC Promotion
DD Promotion
DD Confirmation
EE Transfer
EE Promotion
FF Promotion
FF Transfer
Thanks you
Regards,
Shermaine
not sure if thios is what you want, or how you want to handle the duplicates, but try this...
=IF(ISNUMBER(SEARCH("confirm",VLOOKUP(A2,A11:B23,2,FALSE),1)),"Yes","False")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
FDibbins, this formula is not work for name DD. It only work if the upper action for name is confirm.
Absolute refernces might help..
Please Login or Register to view this content.
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks