Autopopulate a field in one tab by comparing another field in a different tab

[Lata]

Hello,

I would like some help with this problem I'm having:

I have a tab called 'Tab1' in which I have column called 'Col1' and 'Col2'.
I have another tab called 'Tab 2' with columns 'ColA' and 'ColB'. When I enter a text in Col1(Tab1) I would like that text to be compared to data in 'ColA' from Tab 2 and when match found then get the corresponding value from ColB and autopopulate it in Col2 of Tab1.

Any help would be greatly appreciated. Thank You.

LAA

[benishiryo]

hi Lata, welcome to the forum. you could probably use VLOOKUP. see if the attached file helps. you can extend the range in red to whatever you need:
=VLOOKUP(A2,Tab2!$A$2:$B$3,2,0)

do note that uploading a sample Excel file in the thread will enable us to help you better. to upload, press "Go Advanced" beside the "Post Quick Reply" button & click on the paperclip icon
ideally, it should contain your desired results

[Lata]

Thank You so much for your help. I understand what you did but for some reason, when it autopopulates the value from column B in my spreadsheet, it's being inconsistent. It's picking wrong values for the corresponding matching cell. I'm going to play with it and see if it's something else causing it otherwise I'll send you a sample file. Thanks again for your help.