0 Replies Latest reply on Sep 26, 2012 10:54 AM by Michael Sonu

    Look up from two tables

    Michael Sonu

      Hi,

      I have 2 tables like below

       

      Table 1

       

      Row     Name

      123     Ram

      456     Raj

      234   

      438

      564     Rani

       

      Table 2

      Row     Name

      123    

      456    

      234      Ranji

      438     Ravi

      564     Rani

       

       

      Some names are missing in first table and some of them are missing in 2 nd table. I am looking for a formula to check the row number in first table and update the name and if the name is blank in 1st table. It should check the table 2 and update the same. Any help would be highly appreciated

       

      Result

      123     Ram

      456     Raj

      234     Ranji

      438     Ravi