View Single Post
  #4   Report Post  
Max
 
Posts: n/a
Default

.. an error trap to return blanks: "" instead of #NAs

Above will cover the possibility that you may have values in col B which do
not match *exactly* with the reference values in col A in Sheet1

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----