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?
Bookmarks