vlookup & if Lookup_value is matched, return 1 else 2

[hsandeep]

I am doinf vlookup in 2 wokbook. If the Lookup_value in both the workbook is EXACT, then answer=FOUND else NOT FOUND. How to accomplish.
Workbook1
A1=PPP999
Workbook2
A1=PPP999

So, in D1 of workbook2, Answer=FOUND

 

[T. Valko]

I am doinf vlookup in 2 wokbook. If the Lookup_value in both the workbook is EXACT, then answer=FOUND else NOT FOUND. How to accomplish.
Workbook1
A1=PPP999
Workbook2
A1=PPP999

So, in D1 of workbook2, Answer=FOUND

What's your VLOOKUP formula look like?

In general, you can do like this...

=IF(ISNA(VLOOKUP(...)),"NOT FOUND","FOUND")