One way...

=INDEX(Sheet1!B:B, MATCH(A1, Sheet1!A:A, 0))
this can also be dnoe with VLookup but I prefer index match...
--
HTH...

Jim Thomlinson


"Jim" wrote:

Hello,

I would like to ask for help with a formula.

If I have data in two columns of one sheet; and on the second sheet I would
like to bring over only the second column if the data in the first columns
matches - what is hte formula I would use for this?

Example:
Sheet 1 - Column A "jim" Column B "Smith"
Sheet 2 - Column A "jim" column B (formula that would pull over Smith when
it matches the jim).

Thanks for the help.
Jim