Livin404
Well-known Member
- Joined
- Jan 7, 2019
- Messages
- 774
- Office Version
- 365
- 2019
- Platform
- Windows
I have a data based on sheet 'ACTIVITY' and the code am using is in Column D. by references is on the worksheet 'State Country Code'.
I tried using this formula and it doesn't seem to work. I get an error code 2042
Any assistance will greatly be appreciated.
Thank you,
I tried using this formula and it doesn't seem to work. I get an error code 2042
Any assistance will greatly be appreciated.
Thank you,
Excel Formula:
=INDEX('State Country Code'!A2:A10387,MATCH(ACTIVITY!D2,'State Country Code'!B2:B10387,0))