software

I posted a similar question yesterday and I can't find it.

My database worksheet on Column B lists the names of diffrerent clients. On
Column A, there are numbers assigned to the clients on Column B.

Everyday I get a report of the clients (most of the time, multiple names of
a particular client is included in the list) I copy and paste this
information on Column B on my own Worksheet (not the database worksheet).

On Column A on my worksheet, I'd like to have a formula to show the
corresponding assigned number of a client on Column B.

Please help.
It's there, with an answer from Biff

--
Kind regards,

Niek Otten

quot;Dannyquot; gt; wrote in message ...
|I posted a similar question yesterday and I can't find it.
|
| My database worksheet on Column B lists the names of diffrerent clients. On
| Column A, there are numbers assigned to the clients on Column B.
|
| Everyday I get a report of the clients (most of the time, multiple names of
| a particular client is included in the list) I copy and paste this
| information on Column B on my own Worksheet (not the database worksheet).
|
| On Column A on my worksheet, I'd like to have a formula to show the
| corresponding assigned number of a client on Column B.
|
| Please help.
|
|
Thanks for your response Niek. I can't find my posting. I'm looking forward
to see Biff's answer. Can you please give me the exact SUBJECT so I'll search
it again?

quot;Niek Ottenquot; wrote:

gt; It's there, with an answer from Biff
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Dannyquot; gt; wrote in message ...
gt; |I posted a similar question yesterday and I can't find it.
gt; |
gt; | My database worksheet on Column B lists the names of diffrerent clients. On
gt; | Column A, there are numbers assigned to the clients on Column B.
gt; |
gt; | Everyday I get a report of the clients (most of the time, multiple names of
gt; | a particular client is included in the list) I copy and paste this
gt; | information on Column B on my own Worksheet (not the database worksheet).
gt; |
gt; | On Column A on my worksheet, I'd like to have a formula to show the
gt; | corresponding assigned number of a client on Column B.
gt; |
gt; | Please help.
gt; |
gt; |
gt;
gt;
gt;

Here it is:

Hi!

Try this in column D:

=INDEX(A$1:A$4,MATCH(C1,B$1:B$4,0))

Copy down as needed.

Biff

quot;Dannyquot; gt; wrote in message
news
gt; Hi,
gt;
gt; On column A, there are numbers designated to names on col B.
gt;
gt; Col A Col B Col C Col D
gt; 1 aaa bbb 2
gt; 2 bbb ddd 4
gt; 3 ccc ddd 4
gt; 4 ddd ccc 3
gt;
gt; The names on Col C will apprear maybe repeatedly.
gt;
gt; On col D, I'd like to have a formula that will indicate the designated
gt; number of the names as indicated above.
gt;
gt; Please help
quot;Dannyquot; gt; wrote in message
...
gt; Thanks for your response Niek. I can't find my posting. I'm looking
gt; forward
gt; to see Biff's answer. Can you please give me the exact SUBJECT so I'll
gt; search
gt; it again?
gt;
gt; quot;Niek Ottenquot; wrote:
gt;
gt;gt; It's there, with an answer from Biff
gt;gt;
gt;gt; --
gt;gt; Kind regards,
gt;gt;
gt;gt; Niek Otten
gt;gt;
gt;gt; quot;Dannyquot; gt; wrote in message
gt;gt; ...
gt;gt; |I posted a similar question yesterday and I can't find it.
gt;gt; |
gt;gt; | My database worksheet on Column B lists the names of diffrerent
gt;gt; clients. On
gt;gt; | Column A, there are numbers assigned to the clients on Column B.
gt;gt; |
gt;gt; | Everyday I get a report of the clients (most of the time, multiple
gt;gt; names of
gt;gt; | a particular client is included in the list) I copy and paste this
gt;gt; | information on Column B on my own Worksheet (not the database
gt;gt; worksheet).
gt;gt; |
gt;gt; | On Column A on my worksheet, I'd like to have a formula to show the
gt;gt; | corresponding assigned number of a client on Column B.
gt;gt; |
gt;gt; | Please help.
gt;gt; |
gt;gt; |
gt;gt;
gt;gt;
gt;gt;
Thanks a lot Biff. Have a great day!

quot;Biffquot; wrote:

gt; Here it is:
gt;
gt; Hi!
gt;
gt; Try this in column D:
gt;
gt; =INDEX(A$1:A$4,MATCH(C1,B$1:B$4,0))
gt;
gt; Copy down as needed.
gt;
gt; Biff
gt;
gt; quot;Dannyquot; gt; wrote in message
gt; news
gt; gt; Hi,
gt; gt;
gt; gt; On column A, there are numbers designated to names on col B.
gt; gt;
gt; gt; Col A Col B Col C Col D
gt; gt; 1 aaa bbb 2
gt; gt; 2 bbb ddd 4
gt; gt; 3 ccc ddd 4
gt; gt; 4 ddd ccc 3
gt; gt;
gt; gt; The names on Col C will apprear maybe repeatedly.
gt; gt;
gt; gt; On col D, I'd like to have a formula that will indicate the designated
gt; gt; number of the names as indicated above.
gt; gt;
gt; gt; Please help
gt;
gt;
gt;
gt; quot;Dannyquot; gt; wrote in message
gt; ...
gt; gt; Thanks for your response Niek. I can't find my posting. I'm looking
gt; gt; forward
gt; gt; to see Biff's answer. Can you please give me the exact SUBJECT so I'll
gt; gt; search
gt; gt; it again?
gt; gt;
gt; gt; quot;Niek Ottenquot; wrote:
gt; gt;
gt; gt;gt; It's there, with an answer from Biff
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Kind regards,
gt; gt;gt;
gt; gt;gt; Niek Otten
gt; gt;gt;
gt; gt;gt; quot;Dannyquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; |I posted a similar question yesterday and I can't find it.
gt; gt;gt; |
gt; gt;gt; | My database worksheet on Column B lists the names of diffrerent
gt; gt;gt; clients. On
gt; gt;gt; | Column A, there are numbers assigned to the clients on Column B.
gt; gt;gt; |
gt; gt;gt; | Everyday I get a report of the clients (most of the time, multiple
gt; gt;gt; names of
gt; gt;gt; | a particular client is included in the list) I copy and paste this
gt; gt;gt; | information on Column B on my own Worksheet (not the database
gt; gt;gt; worksheet).
gt; gt;gt; |
gt; gt;gt; | On Column A on my worksheet, I'd like to have a formula to show the
gt; gt;gt; | corresponding assigned number of a client on Column B.
gt; gt;gt; |
gt; gt;gt; | Please help.
gt; gt;gt; |
gt; gt;gt; |
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

You're welcome!

Biff

quot;Dannyquot; gt; wrote in message
...
gt; Thanks a lot Biff. Have a great day!
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; Here it is:
gt;gt;
gt;gt; Hi!
gt;gt;
gt;gt; Try this in column D:
gt;gt;
gt;gt; =INDEX(A$1:A$4,MATCH(C1,B$1:B$4,0))
gt;gt;
gt;gt; Copy down as needed.
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;Dannyquot; gt; wrote in message
gt;gt; news
gt;gt; gt; Hi,
gt;gt; gt;
gt;gt; gt; On column A, there are numbers designated to names on col B.
gt;gt; gt;
gt;gt; gt; Col A Col B Col C Col D
gt;gt; gt; 1 aaa bbb 2
gt;gt; gt; 2 bbb ddd 4
gt;gt; gt; 3 ccc ddd 4
gt;gt; gt; 4 ddd ccc 3
gt;gt; gt;
gt;gt; gt; The names on Col C will apprear maybe repeatedly.
gt;gt; gt;
gt;gt; gt; On col D, I'd like to have a formula that will indicate the designated
gt;gt; gt; number of the names as indicated above.
gt;gt; gt;
gt;gt; gt; Please help
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;Dannyquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Thanks for your response Niek. I can't find my posting. I'm looking
gt;gt; gt; forward
gt;gt; gt; to see Biff's answer. Can you please give me the exact SUBJECT so I'll
gt;gt; gt; search
gt;gt; gt; it again?
gt;gt; gt;
gt;gt; gt; quot;Niek Ottenquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; It's there, with an answer from Biff
gt;gt; gt;gt;
gt;gt; gt;gt; --
gt;gt; gt;gt; Kind regards,
gt;gt; gt;gt;
gt;gt; gt;gt; Niek Otten
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Dannyquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; |I posted a similar question yesterday and I can't find it.
gt;gt; gt;gt; |
gt;gt; gt;gt; | My database worksheet on Column B lists the names of diffrerent
gt;gt; gt;gt; clients. On
gt;gt; gt;gt; | Column A, there are numbers assigned to the clients on Column B.
gt;gt; gt;gt; |
gt;gt; gt;gt; | Everyday I get a report of the clients (most of the time, multiple
gt;gt; gt;gt; names of
gt;gt; gt;gt; | a particular client is included in the list) I copy and paste this
gt;gt; gt;gt; | information on Column B on my own Worksheet (not the database
gt;gt; gt;gt; worksheet).
gt;gt; gt;gt; |
gt;gt; gt;gt; | On Column A on my worksheet, I'd like to have a formula to show the
gt;gt; gt;gt; | corresponding assigned number of a client on Column B.
gt;gt; gt;gt; |
gt;gt; gt;gt; | Please help.
gt;gt; gt;gt; |
gt;gt; gt;gt; |
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;