yogi_LookUp An Entity Name Such As Nationality From A Table Based On Values In Two Columns Such as First name And Last Name

                                          Google Spreadsheet   Post  #1046
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Feb 25, 2013
user Plentira said:(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/5CNv7fipSls)
Help with formula to cross-reference values
Hello!

I would have used the search function, had I been able to formulate my question in a succinct manner. :-)

My workbook has a sheet in which all participants in a course are listed, including their nationality (sheet A). Another sheet (downloaded externally), has a list with all participants that have successfully received a certificate for the course (sheet B) - alas without their nationality.

I am trying to write a formula that would search sheet A for names present on sheet B, and when found add the corresponding value for 'nationality' in sheet B.

Is this possible? Thanks in advance for the help.

---------------------------------------------------------------------------------------------------------------

following is a solution to the problem