| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Simplify Vlookup function in Excel
When using Vlookup, the function asks for a table array. I'd like to suggest
a change to the function. Provide a one column range, then allow the function to find it ## rows over. For example, instead of: =Vlookup(A1,C:G,5,false) simply: =Vlookup(A1,C:C,5,false) This may seem minor, but when you're doing a lot of reference work in one spreadsheet, the current function requirements are fairly time consuming. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Improve Convert function in Excel | Excel Worksheet Functions | |||
| Access Module coded converted to Excel Function | Excel Discussion (Misc queries) | |||
| Does Excel 2000 have a 'datedif' function to calculate the number. | Excel Worksheet Functions | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
| Missing function in Excel 2003 | Excel Discussion (Misc queries) | |||
Threaded Mode
