ExcelBanter - Match

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

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

- - Match (https://www.excelbanter.com/excel-worksheet-functions/126384-match.html)

iamjbunni

Match

I have values in column A and B on another tab in my worksheet. On a
separate tab, I have other values in Column A. I want a formula that looks
at Cell A1, Sheet 1 and matches it to the same value in Column A, sheet 2 and
enters the value that is next to the matching value in column b, sheet 2.

Any suggestions?

daddylonglegs

Match

In Sheet 1 B1

=VLOOKUP(A1,sheet2!A:B,2,0)

copied down

"iamjbunni" wrote:

I have values in column A and B on another tab in my worksheet. On a
separate tab, I have other values in Column A. I want a formula that looks
at Cell A1, Sheet 1 and matches it to the same value in Column A, sheet 2 and
enters the value that is next to the matching value in column b, sheet 2.

Any suggestions?

All times are GMT +1. The time now is 04:51 PM.