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