Vlookup and replace

[Zan_1]

Hi

i have two table call it table 1 and table 2 

  For example: it should generate table 3 

basically search for 12345 batch in table 1 for student ID if found input in student I’d column in table 3 , if it’s not found for the case case 1444 batch number than it should just pick student id from table 2 

also batch student ID should be in text in the final generated table

thank you

[flying008 · Accepted solution]

Hi, @Zan_1 

FYI.

[Zan_1]

Hi that solution worked 

however I have another question 

 I want to use table 1 and table 2 and creat new table that shows all the differences 

[AndrewDMerrill]

Here is a sample workflow that I believe meets your needs: