I am trying to create an inquiry that pulls all of my items together by the month so that I can export it to further work with it in Excel rather than run three different reports. I am running into an issue when I have mutliple "Union Class" items being calculated on one Fringe ID (Pension, H&W mainly since these are different rated depending on the Union I am working for).

I am currently using a Lookup formula to pull this information but I am only getting one line of data rather than the two or more Union Classes that calculated during the payroll run (see last clipping).

Current Formula:

Results on the Union - PEN line calculates but only shows the "HH" Union Class. This is also a problem with the Union - H&W column.

What I need is to total the Union Classes "HH" and "J" for a total of $129.68 as seen in the Fringe Inquiry currently in payroll.

Any help or ideas would be appreciated!