Excel Macro To Lookup a User Entered String, and return data from the field next to it

Posted by CJG on Super User See other posts from Super User or by CJG
Published on 2012-10-11T01:41:49Z Indexed on 2012/10/13 15:43 UTC
Read the original article Hit count: 168

On worksheet A, a user is prompted to enter a product number, such as BCI610. On worksheet B somewhere, that value exists.

I want to lookup/find that value, and then return the data in the cell that is right next to it one column to the right, by copying that data, and pasting it somewhere in worksheet A.

If I enter BCI610, it should return the value M332651, because that is the number in the cell immediately to the right of BCI610.

I tried VLookup and HLookup, but to no avail... Any suggestions?

© Super User or respective owner

Related posts about microsoft-excel

Related posts about worksheet-function