Unable to get ipac4 controls to work within MAME games

[TheDude101010]

I am struggling to find any resource that details how to actually get my IPAC4 keyboard input controls to work properly within MAME games. I have mapped the controls within BigBox and can navigate there with no issue. After watching a video, I figured that going through Mame to map all 4 sets of controls (U/D/L/R + 6 buttons + start + select) that I'd be fine within each game but the controls are 99% not responsive once I kick off a game...and those that are are completely random and not what's mapped. Desperate for help on what I feel should be fairly simple after I've done the hard work. Attached is an example of my mappings detailed in excel as well as an example of the mame input screen where i've correctly mapped all of these. Only the start button works as designed once I launch a game. Beyond frustrated because there don't seem to be any resources on the topic. Help!