Thread: Match
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
 
Posts: 833
Default Match

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