Dear all

This problem is killing my time since long.. Vlookup works only on exact
matches or approximate matches. Choosing the TRUE (approximate matches)
option in the 4th argument of the function is fraught with danger as it might
throw unexpected and wrong results.

I have two data tables with KEY FIELD data as below

table 1 table 2
GUJ-Prayag Raj Complex, Kalol Prayag Raj
GUJ-Dhartimanan Complex, mehsa Dharti

Table 2 has the following structure

key field value required in table1
Dharti GUJMEH0355


Trying to populate the value GUJMEH0355 in a column to the right of the key
field in table1. vlookup is failing as it says 'Dharti' and 'GUJ-Dhartimanan
Complex, mehsa' are not matching strings!!!

Please help out..