Automatically lookup and set an empty cell's value if adjacent cell is typed & vice versa

2 Sheets: "Database" and "Client Codes"
On Sheet Database,

Cell B4 is where one would type a Code Number.

Cell C4 is where one would type the corresponding Client Name.

On Sheet Client Codes,

Column A2 and down are Code Numbers.

Column B2 and down are corresponding Client Names.

I am hoping to make a Worksheet_Change that looks at Sheet Database Cells B4 and C4 and uses a Index match function to lookup the corresponding Number/Name from Sheet Client Codes.

I started with a Sub button to simply see if I could make it work. The Index Match formula is returning a 1004 error. The next step would be to make it a Worksheet_Change private sub that makes things simple for someone entering data.

Please Login or Register  to view this content.

Thanks for taking the time to look,
Red

Originally Posted by walruseggman

Need to rewrite.

Thanks I'll try :/

Maybe:

Please Login or Register  to view this content.

The sheet is a little sensitive and making a dummy one would take a considerable amount of time but thank you guys for your assistance thus far!
John I think nailed it, ditching the INDEX MATCH entirely and just going for a find. It exceeds my expectations :D
Definitely a lot easier to comprehend than making the worksheet formulas work.
Best,
Red