The information was matching up, but it returned the #N/A error anyway.
After investigating for a while, this is what I found...

On the Highmark run worksheet, if the numbers to match up had a green tag on
the upper left corner of the cell, I did the following:

Clicked in the cell
Clicked the "Smart Tag" that appeared on the right
Choose Convert to Number

This returned the number needed instead of the #N/A----Whew hew!!! Thank
you all for your input.

Wanda Garner
Highmark Blue Shield


"Pete" wrote:

If you want to avoid the error, you can amend your formula as follows:

=IF (ISNA(Vlookup formula), 0 , Vlookup formula)

This will return a zero instead of #N/A

Pete