ExcelBanter - Lookup Question

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Lookup Question (https://www.excelbanter.com/excel-worksheet-functions/226817-lookup-question.html)

I am sure this has been answered before...but I have one sheet of data that
has a number in column A, then a second sheet that has 2 columns, one with a
number that will match some of the numbers on Sheet 1 in Column A and have a
corresponding number in Column B. I want to match the information from Sheets
1 and Sheets 2 Column As and enter on Sheet 1 the information in Column B
from Sheet 2

Example:
Sheet 1:

123-1234

Sheet 2:
Column A Column B
59871 5
123-1234 8

Thanks for your help!

In article ,
Shood wrote:

I am sure this has been answered before...but I have one sheet of data that
has a number in column A, then a second sheet that has 2 columns, one with a
number that will match some of the numbers on Sheet 1 in Column A and have a
corresponding number in Column B. I want to match the information from Sheets
1 and Sheets 2 Column As and enter on Sheet 1 the information in Column B
from Sheet 2

Example:
Sheet 1:

123-1234

Sheet 2:
Column A Column B
59871 5
123-1234 8

Thanks for your help!

Assuming that A2:B100 on Sheet2 contains the source data/table, and A2
on Sheet1 contains the lookup value, try...

=VLOOKUP(Sheet1!A2,Sheet2!$A$2:$B$100,2,0)

--
Domenic
http://www.xl-central.com