How to vlookup 2 ws & get 1 output

[hsandeep]

I am doing vlookup in 2 different workbooks. If Lookup_value of both the ws MATCHES EXACTLY, I want Y5 (DATA AVAILABLE) else Z5 (DATA NOT AVAILABLE).
Ex;
Workbook1:
A4=kkk-888&$
Workbook2:
C4=kkk-888&$

So in workbook2, in cell D4=DATA AVAILABLE.

 

[Aladin Akyurek]

I am doing vlookup in 2 different workbooks. If Lookup_value of both the ws MATCHES EXACTLY, I want Y5 (DATA AVAILABLE) else Z5 (DATA NOT AVAILABLE).
Ex;
Workbook1:
A4=kkk-888&$
Workbook2:
C4=kkk-888&$

So in workbook2, in cell D4=DATA AVAILABLE.

D4, something like...

="DATA"&IF(ISNUMBER(MATCH(C4,[Book1.xlsx]Sheet1!A:A,0)),"","NOT")&" AVAILABLE"

 

[hsandeep]

IT WORKS. Can I do like: I punch DATA AVAILABLE in X1 & DATA NOT AVAILABLE in Y1 & get X1 or Y1 as the case is?
Moreover, than I want to count Nos of occurences of DATA AVAILABLE & DATA NOT AVAILABLE also. Please help.

 

[Aladin Akyurek]

IT WORKS. Can I do like: I punch DATA AVAILABLE in X1 & DATA NOT AVAILABLE in Y1 & get X1 or Y1 as the case is?
Moreover, than I want to count Nos of occurences of DATA AVAILABLE & DATA NOT AVAILABLE also. Please help.

D4, copy down...

=IF(ISNUMBER(MATCH(C4,[Book1.xlsx]Sheet1!A:A,0)),$X$1,$Y$1)

X2, copy to Y2...

=COUNTIF($D:$D,X$1)

 

[hsandeep]

It works. Thank you.

 

[Aladin Akyurek]

It works. Thank you.

You are welcome. Thanks for providing feedback.