| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Vlookup - return row no. instead of value
Dear all,
For vlookup, it will return the value of the destination cell. Is it possible to return the row no. instead of value of the destination cell?? Your help is highly appreciated. Thanks & regards, Automne |
|
#2
|
|||
|
|||
|
Look at the MATCH function in Help.
On Sat, 5 Mar 2005 01:41:39 +0800, "automne" wrote: Dear all, For vlookup, it will return the value of the destination cell. Is it possible to return the row no. instead of value of the destination cell?? Your help is highly appreciated. Thanks & regards, Automne |
|
#3
|
|||
|
|||
|
On Sun, 06 Mar 2005 17:35:16 -0600, Myrna Larson
wrote: Look at the MATCH function in Help. or add another column with the row number in it ... On Sat, 5 Mar 2005 01:41:39 +0800, "automne" wrote: Dear all, For vlookup, it will return the value of the destination cell. Is it possible to return the row no. instead of value of the destination cell?? Your help is highly appreciated. Thanks & regards, Automne |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
| Can VLOOKUP return multiple answers based on several identical lo. | Excel Worksheet Functions | |||
| VLookup Return Value | Excel Worksheet Functions | |||
| Can vlookup return multiple matches in a single cell? | Excel Discussion (Misc queries) | |||
| vlookup and IF function | Excel Worksheet Functions | |||
Linear Mode
