Since it appears that there might be a leading zeros issue, try this 2nd
revision, the TEXT bit will help improve it for consistent matching. In D2,
copied down:
=IF(ISNA(MATCH(TEXT(D2,"000"),Sheet2!A:A,0)),"",IN DEX(Sheet2!B:B,MATCH(TEXT(D2,"000"),Sheet2!A:A,0)) )
Let me know here how it goes with you
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"gmoore" wrote:
Then what is the next step to solve the problem?