Conditional VLOOKUP
 

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

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

Thanks Max.

"Max" wrote:

Perhaps try instead these:

In B2: = IF(A2="","",VLOOKUP(A2,Master,8))
In C2: = IF(A2="","",IF(EXACT(B2,C$1)=TRUE,"","ERROR"))

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Robert" wrote:
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

You're welcome, Robert!
Thanks for posting back
--
Rgds
Max
xl 97
---
GMT+8, 1=B0 22' N 103=B0 45' E
xdemechanik <atyahoo<dotcom
----
"Robert" wrote:
Thanks Max.