| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I create an equivalent VLOOKUP function using FIND?
I wish to create an equivalent search algorithm using FIND to produce similar
results to if I was using VLOOKUP. Basically VLOOKUP does everything I want to do but is not case specific when looking through cell ranges. I need a case specific VLOOKUP. I have an array and wish to be able to search through for a value say 'a' (different to 'A') and then return the data in the 4th column from it. In VLOOKUP 'speak' I have =VLOOKUP(a, $A$2:$Z:3000, 4, FALSE). Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP Function | Excel Discussion (Misc queries) | |||
| How do I access data stored in a SQL server for vlookup function? | Excel Worksheet Functions | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| clock | Excel Worksheet Functions | |||
| Simplify Vlookup function in Excel | Excel Worksheet Functions | |||
Threaded Mode
