Match - Exact - Lookup?
 

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.

Match - Exact - Lookup?
 

It's there, with an answer from Biff

--
Kind regards,

Niek Otten

"Danny" 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.
|
|

Match - Exact - Lookup?
 

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?

"Niek Otten" wrote:

It's there, with an answer from Biff

--
Kind regards,

Niek Otten

"Danny" 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.
|
|

Match - Exact - Lookup?
 

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

"Danny" wrote in message
...
Hi,

On column A, there are numbers designated to names on col B.

Col A Col B Col C Col D
1 aaa bbb 2
2 bbb ddd 4
3 ccc ddd 4
4 ddd ccc 3

The names on Col C will apprear maybe repeatedly.

On col D, I'd like to have a formula that will indicate the designated
number of the names as indicated above.

Please help



"Danny" wrote in message
...
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?

"Niek Otten" wrote:

It's there, with an answer from Biff

--
Kind regards,

Niek Otten

"Danny" 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.
|
|

Match - Exact - Lookup?
 

Thanks a lot Biff. Have a great day!

"Biff" wrote:

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

"Danny" wrote in message
...
Hi,

On column A, there are numbers designated to names on col B.

Col A Col B Col C Col D
1 aaa bbb 2
2 bbb ddd 4
3 ccc ddd 4
4 ddd ccc 3

The names on Col C will apprear maybe repeatedly.

On col D, I'd like to have a formula that will indicate the designated
number of the names as indicated above.

Please help



"Danny" wrote in message
...
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?

"Niek Otten" wrote:

It's there, with an answer from Biff

--
Kind regards,

Niek Otten

"Danny" 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.
|
|

Match - Exact - Lookup?
 

You're welcome!

Biff

"Danny" wrote in message
...
Thanks a lot Biff. Have a great day!

"Biff" wrote:

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

"Danny" wrote in message
...
Hi,

On column A, there are numbers designated to names on col B.

Col A Col B Col C Col D
1 aaa bbb 2
2 bbb ddd 4
3 ccc ddd 4
4 ddd ccc 3

The names on Col C will apprear maybe repeatedly.

On col D, I'd like to have a formula that will indicate the designated
number of the names as indicated above.

Please help



"Danny" wrote in message
...
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?

"Niek Otten" wrote:

It's there, with an answer from Biff

--
Kind regards,

Niek Otten

"Danny" 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.
|
|