Problem involving approximate table look-up and return value

[pjigglez]

Hello all,

So this is the layout of my problem. I have one workbook that has first and last name in two separate columns. Column A is First Name, Column B is Last Name. I have another workbook in which Column A's data takes the form of "Last Name, First Name Middle Initial" . Workbook 2 is a table of the names of clients that qualify under the value, "Risk". Workbook 1 is just the general list of all clients. How would I make excel check those who qualify "risk" in workbook 2, and insert the value "risk" next to the names in Workbook 1.

Thank in advance!

[NBVC]

Possibly something like:


=VLOOKUP(B2&", "&A2&"*",'Sheet2'!A:B,2,0)

or

=VLOOKUP(B2&"*"&A2&"*",'Sheet2'!A:B,2,0)

where Sheet2 column B contains the word to extract.

If you don't want other words to be pulled and only if it is "Risk" then wrap an IF() function

=IF(VLOOKUP(B2&"*"&A2&"*",'Sheet2'!A:B,2,0)="Risk","Risk","")