Friday, December 6, 2019

Vlookup

=VLOOKUP(G2,Sheet2!B:H,7,TRUE)
=VLOOKUP(A2,Sheet2!B:B,1,0)

=VLOOKUP(currentsheetcolumn,Sheet2!B:H,7,0)
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Create rpm and deb using fpm

Create rpm and deb using fpm  fpm -s dir -t rpm -n unbound-exporter -v 1.0 --prefix /usr/bin unbound_exporter   fpm -s dir -t rpm -n unbound...

  • How to run ansible playbook with sudo command
    #Following steps will cover how to run ansible playbook with sudo passwd saved  1) Install Ansible (...
  • Splunk Admin Notes
    Splunk admin ------------ indexer search head forwarder deployment server licence master cluster master Indexer - Indexing par...
  • Sed All in One Guide
    SED Guide -------------- ###FEATURES COMMON TO BE BOTH AWK & SED ####  1. Both are scripting languages  2. Both work primarily w...