| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
vlookup to provide row reference instead of value
I am trying to get the row reference from a vlookup not the value.
A: B Shop : sales I have repeating records for 100 shops and I am trying to get the row reference for the first & last record for each shop so that I can use it in a TTEST function |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
| Vlookup will not reference a validation/drop down box | Excel Discussion (Misc queries) | |||
| Using a cell reference of a sheet in Vlookup | Excel Worksheet Functions | |||
| Convert VLOOKUP to absolute cell reference | Excel Discussion (Misc queries) | |||
| Vlookup reference a worksheet | Excel Worksheet Functions | |||
Threaded Mode
