| View previous topic :: View next topic |
| Author |
Message |
venkat
Power User
Joined: 11 Nov 2003
Posts: 64
|
 Posted: Tue Dec 23, 2003 11:19 pm Post subject: vlookup |
 |
|
Dear All,
I am using VLOOKUP to compare, if i am comparing the string "LBDEL00000000087";
if the exact string is not there, then it searches for the individiual characters
for eg it returns the value if i have "LBDEL00000001687"
I have solved this using if condition.
But how would i acheive this without using if condition, like excel.
Venkat |
|
| Back to top |
|
 |
dfrench
Moderator
Joined: 03 Mar 2003
Posts: 1605
Location: Wellington, New Zealand
|
| Posted: Mon Dec 29, 2003 10:12 am Post subject: |
|
|
| You can force an exact match by setting the 4th parameter of vlookup (sort order) to False. See the Help for a description of how this function works. |
|
| Back to top |
|
|
|
