Showing posts with label Office. Show all posts
Showing posts with label Office. Show all posts

Wednesday, June 19, 2019

Some Common Used Excel Formulas

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.