Match - Exact - Lookup?

[Guest]

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.

 

[Niek Otten]

It's there, with an answer from Biff

--
Kind regards,

Niek Otten

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

 

[Guest]

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?

 

[Biff]

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

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

 

[Guest]

Thanks a lot Biff. Have a great day!

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

 

[Biff]

You're welcome!

Biff

Thanks a lot Biff. Have a great day!