Match

J

Jim

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
 
J

Jim Thomlinson

One way...

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

KC hotmail com>

Assuming Sheet2 starts on row 2:
=if(iserror(vlookup(A2,Sheet1!A:A,1,0)),"",vlookup(A2,Sheet1!A:B,2,0))
This will return only the first instance of a match...so in your example, if
you had 3 Jim's in your list, it would return the first one it can find in
Sheet1, regardless of the order in Sheet1. Also note the list in Sheet1 does
not need to be alphabetized with this formula (the vlookup with ,0 at the end
means find an exact match in an unsorted list).
 
T

trip_to_tokyo

You don’t’ say what is happening further down the column(s) so it’s a bit
difficult to give a definitive reply.

I have just put up a file for you at:-

http://www.pierrefondes.com/

It is item number 41 towards the top of my home page.

This may be what you want.

In Sheet2 entry into cells A2:A6 of any of the names appearing in Sheet1
cells A2:A6 will cause the associated surname to echo back in Sheet2 cells
B2:B6.

Please hit Yes if my comments have helped.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top