search 2 keys

I have 3 tables: Table1- for First data (dynamic data, get from other sheet) Table2- Reference to get "score" Table3- Final result "score" We need to read first var in Table2, compare with first var in Table1, then do some compare like folowwing (I have them inside sheet attach) Step 1...

Hi All, I have a sheet called "DATA" that has dates in Column C and Email addresses in Column B On another sheet I am going to have Email addresses (there may be 2 email addresses in a single cell separated by a "," ) in Column B and a date in Cell A1. Is there a formula where I can pull the...

Hi I want when I don't now exact name, and type for example "b*0" then show result by "b20, b-20, b-120, b-30 cms-c and ..." thanks

Hello, I have to search a long list only column A if there is any word with an Uppercase letter following by the second in Lowercase. Difficult to explain.... Column.........................Column A.......................................B Doris Angel........................."" Ruper...

Here i make an example table, and the main task what i want to do. an excel file mix of lawyers and agencies names mixed under a single column. I want fill column D with yes if the Stuff in A is Law agency, (using search terms attys, inc. bar, assn) like this and seprate the agencies from the...

I'm trying several options but no one works. Let's see if anyone can help me. I have a sheet with country information, like: <table width="923" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64"> <col style="width: 76pt;" width="101"> <col style="width: 48pt;"...