| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to get reference of a cell instead of value in the cell
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to get reference of a cell instead of value in the cell
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 --- Regards, Norman "nishad" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to get reference of a cell instead of value in the cell
If Norman's filter is not applicable, check out the example in Help for the
FindNext Method. Combine with Union maybe. NickHK "nishad" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Hybrid Mode
