You dont say what is happening further down the column(s) so its 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.
"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