look up name from inputted ticket number

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lifeisreel - 25 Sep 2006 17:20 GMT

I am running a raffle. I have one worksheet with peoples names and a
associated number. I have a second worksheet with the raffle ticket numbers
and the associated number of the person who purchased the ticket. I need to
be able to enter the ticket number and have the persons name come up.

Reply to this Message

Steve Schapel - 25 Sep 2006 19:32 GMT

Lifeisreel,

The focus of this newsgroup is Macros in Microsoft Access, the database
programme. It seems like you are talking Excel or some other
spreadsheet. I think this functionality is possible with Excel, but not
sure how - maybe reposting your question to an Excel-related newsgroup
would be the way to go. If this information was in two Access tables,
it would done via a simple Query.

Signature

Steve Schapel, Microsoft Access MVP

> I am running a raffle. I have one worksheet with peoples names and a
> associated number. I have a second worksheet with the raffle ticket numbers
> and the associated number of the person who purchased the ticket. I need to
> be able to enter the ticket number and have the persons name come up.

Reply to this Message