VLookup N/A Error
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
|