Trying to search for the result in the column to the left of the reference.

[Beach Walker]

Hi

See the attachment.

I am looking to find the result in the column to the left of the reference so cant use vlookup because it wont accept a negative cell count. In the attachment I am looking to search the Product in column D and find the matching code for it in column C.

Thanks

1.xlsx

[sktneer]

Try this.....

Please Login or Register  to view this content.

Does this help?