Monday, February 25, 2013

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    Feb 25, 2013
user Plentira said:(!category-topic/docs/spreadsheets/5CNv7fipSls)
Help with formula to cross-reference values

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