Am trying to populate data from MASTER into sub tables. Have the flwg
formulas:-
C1 BOOKS (example)
B2 =If(A2="""","""",(VLOOKUP(A2,MASTER,8)))
C2 =IF(EXACT(B2,C$1)=TRUE,"","ERROR")
Assistance required, when A2 is " " (blank) C2 should be blank as well.
--
Robert