Cell value based on table

[barry.reeder]

Hello,

I have 15K ID numbers in column A, and I need to populate cells in column B based on a table from sheet 2 in the same book. This table links data in column A with B. (see below). What formula do I enter in B2 on the first sheet? -Thanks!

Sheet 1
A B
1234
2234
3334
4455

Sheet 2
A B
1234 Kentucky
2234 Georgia
3334 Maine
4455 Texas

 

[VoG]

Try

=VLOOKUP(A2,Sheet2!A:B,2,FALSE)

 

[barry.reeder]

Thank you so much, saved me hours of work!