Some of my formulas used in my work:1. Matching and Return Value Crossing Different Columns
1.1
=IF( COUNTIF('Servers'!A:A, A3)=0, "No", "Yes")
Check if A3 value is in worksheet "Servers" column A. If found , show Yes, else, show No
1.2
=VLOOKUP(A3,'Z:\0 Operation\1 Scan\Servers\Jan 2019\[Scan_Report_Server_Urgent_Vuls.xlsx]APP IP'!A:H,8,)
Check if A3 value found in the file "Z:\0 Operation\1 Scan\Servers\Jan 2019\[Scan_Report_Server_Urgent_Vuls.xlsx" - worksheet "APP IP' - Column A to H. If found, return same row's , eighth column's value.
