PDA

View Full Version : User Defined Lookup Function



vishwakarma
10-19-2010, 11:44 PM
Hello guys...

I've a list of values(words) in a column and want to compare and search them from another column (just like we do using vlookup function). But here the problem is that the values(words) are not exact, so I need a function through which we can look for the key words and give me either rows number of the string containing the key words...Is that possible?


Thanks in Advance...

austenr
10-20-2010, 08:07 AM
You could use VB Script to do what you want, but then again thats not what you asked for.

mdmackillop
10-20-2010, 01:37 PM
It's not too clear how the results are determined.