On Dec 26, 12:43*am, "Max" wrote:
As to your lines:

How to avoid the #NA?
I have attempted =if(isseror(Vlookup(D8,Drate,3,False) ))

The first step is to ensure that thevlookupis indeed working properly.
The earlier suggestions should take care of that.

For error trapping of "true" #N/A returns,
you could use IF(ISNA(...), in this manner:
=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))
which will return "blanks", viz.: "" for any unmatched cases
(you could amend the "blanks" return to suit)

An example would be, say in J8:
=IF(ISNA(VLOOKUP(ROUND(D8,2),Frate,3,TRUE)),"",VLO OKUP(ROUND(D8,2),Frate,3,*TRUE))
--
Max
Singaporehttp://savefile.com/projects/236895
xdemechanik
--- *

Outstanding, Max OUTStanding, OutSTANDING!!!

Thank you Max: Thank you for plowing through my muddled word problem;
gleaning a solution from the mis-information and understated
information; for creating the logic needed in the solution that would
fix my error and most of all for taking the time to derive an idiot
proof solution for me, which is the only solution I would have been
able to grasp.

What a wonderful gift, as you can now understand, I truly wanted to
say many thanks to you Max.

Please have a safe Holiday and thanks for putting my mind at ease, so
that I can now Welcome the New Year in with Excel treats,

George