I've tried several variations to get this to work.. the old/current version of the sheet works, but as the scope of projects went up the code doesn't keep from showing multiple entries from the same cust. I just can't seem to get the structure right..



All it has to do is match a value from Col D on sheet 1 to a value on Sheet 2 Col H and return the unique ID in Sheet 2 Col A .


My attempts are on the top half of sheet 1


the current look up is on the bottom of sheet 1


Any help will be greatly appreciated...

Attached Files

Example 1-1.xlsx (12.0 KB, 6 views)