On 20 Apr, 12:57, Les Stout wrote:
Hi all, i have done a normal Vlookup from one workbook to another but it
returns incorrect results ?? I select the part number 8036682 and it
returns info for 8036553 ???
Can anybody shed some light on this ??
p.s.
The format is the same

SORRY FIRST NUMBER WAS WRONG

Les Stout

*** Sent via Developersdexhttp://www.developersdex.com***

Les,

The table must be sorted in ascending order AND to get an exact match
the Range_Lookup must be entered as FALSE

Regards

Michael Beckinsale