how to get reference of a cell instead of value in the cell

[Guest]

Hi all, i am making a programme in which we can search for extn no of any
employee in our company. i am using vlookup function to search for the
extention number. suppose i enter the name "amit" it gives me the first
search even if there are more than one employees with the same name. i want
something like if i enter "amit" it should give all results who are with the
same name.
Thanks & Regards

 

[Norman Jones]

Hi Nishad,

Perhaps, consider using Excel's Autofilter.

If you are not familiar with this feature, see
Debra Dalgleish's tutorial at:

Excel -- Filters -- AutoFilter Basics
http://www.contextures.com/xlautofilter01.html

 

[NickHK]

If Norman's filter is not applicable, check out the example in Help for the
FindNext Method.
Combine with Union maybe.

NickHK