Is Vlookup appropriate

[Amandac6772]

I have a spreadsheet I need to add tax ids to but tax ids are on the second tab. I want to match it with vendor number. Would vlookup be appropriate and how would it work? Say the vendor numbers are in column A on both tabs but the tax Id is on tab 2 in column b.

 

[petertenthije]

=vlookup('first tab'!A1,'second tab'!A:B,2,false)

 

[Amandac6772]

V

=vlookup('first tab'!A1,'second tab'!A:B,2,false)

Thank you! I’ll give it a try.