Perhaps try instead these:

In B2: =3D IF(A2=3D"","",VLOOKUP(A2,Master,8)) =20
In C2: =3D IF(A2=3D"","",IF(EXACT(B2,C$1)=3DTRUE,"","ERROR"))

--
Rgds
Max
xl 97
---
GMT+8, 1=B0 22' N 103=B0 45' E
xdemechanik <atyahoo<dotcom
----
"Robert" wrote:
Am trying to populate data from MASTER into sub tables.=20
Have the flwg=20
formulas:-
C1 BOOKS (example)
B2 =3DIf(A2=3D"""","""",(VLOOKUP(A2,MASTER,8)))
C2 =3DIF(EXACT(B2,C$1)=3DTRUE,"","ERROR")
Assistance required, when A2 is " " (blank) C2 should be=20
blank as well.
--=20
Robert