Fetch value of a cell based on dropdown menu items results on another sheet

I have 2 Sheets named as Sheet1 and Sheet2…

Sheet1: Contains Drop down list on B4 Column. Based on the selection of an item, it pulls the result of the open price shown on D4 column.

Sheet2: Contains 2 Columns. Based on Column 1 Id It needs to get the open price from Sheet 1 and should be shown in column 2 of Sheet 2…

Note: I don’t want to modify sheet1 and 2 in any way… Please don’t add any additional column in sheet1 and 2…Using that I can achieve the result…

Without modifying any criteria I need to get the result cause I will be retrieving past data and will do some complex operations on that…

link Sheets

nmap gives different results in two shells on the same computer

I’m running kali and metasploitable2 in Virtualbox, and have them connected via the host-only networking mode. I can ping and ssh from kali to metasploitable, and have assigned the following IP addresses: (kali) and (metasploitable). For some reason, I was unable to see most open ports when running a simple scan:

kali$   nmap -sV Starting Nmap 7.70 ( https://nmap.org ) at 2019-06-16 09:04 CEST Nmap scan report for Host is up (0.011s latency). Not shown: 997 filtered ports PORT     STATE SERVICE     VERSION 80/tcp   open  http? 443/tcp  open  https? 8080/tcp open  http-proxy? 

But if I open another shell and run the same command I get a very different result:

kali$   nmap -sV Starting Nmap 7.70 ( https://nmap.org ) at 2019-06-16 09:05 CEST Nmap scan report for Host is up (0.00029s latency). Not shown: 977 closed ports PORT     STATE SERVICE     VERSION 21/tcp   open  ftp         vsftpd 2.3.4 22/tcp   open  ssh         OpenSSH 4.7p1 Debian 8ubuntu1 (protocol 2.0) 23/tcp   open  telnet      Linux telnetd 25/tcp   open  smtp        Postfix smtpd 53/tcp   open  domain      ISC BIND 9.4.2 80/tcp   open  http        Apache httpd 2.2.8 ((Ubuntu) DAV/2) 111/tcp  open  rpcbind     2 (RPC #100000) 139/tcp  open  netbios-ssn Samba smbd 3.X - 4.X (workgroup: WORKGROUP) 445/tcp  open  netbios-ssn Samba smbd 3.X - 4.X (workgroup: WORKGROUP) 512/tcp  open  exec        netkit-rsh rexecd --- snip ---- 

This is a potentially very much a beginner question but what could be giving these differences between the shells? The env variables were identical in both.

`drush uli` generates correct link but results in ‘Access Denied’

I have set up a Drush alias for my website (hosted on a shared hosting), the alias works correctly, because commands like drush status, drush cc all, etc. work. The problem comes with drush uli. It generates the one-time login link, the domain is correct, everything looks all right, but when entered into a browser, it results in standard Drupal

Access Denied


Part of setting up the alias and some interesting issues around path-alias-es, relations to database settings, it’s usage and relevancy the aliases is originally discussed in Drush issues page on GitHub.

Technical information:

  • This is a clean Drupal 7 installation, without contrib modules.
  • I can log in using password (even using password set via drush upwd using the same alias).
  • I have checked all possible sources (like truncating sessions table, etc.) discussed in similar but yet different issue on StackExchange.
  • I have tried different browsers and cleared browser caches and cookies as suggested in various similar discussions on Drupal.org, all without luck.

Drush alias:

$  aliases['myalias'] = array(   'uri' => 'mysite.com',   'root' => '/home/mysite.com/web',   'path-aliases' => array(     '%drush' => '/home/.composer/vendor/drush/drush',    ),   '%files' => '/home/mysite.com/web/sites/mysite.com/files', );  

The alias works correctly for other commands like clearing caches and drush status confirms that Drupal is bootstrapped correctly.

Testing transfer of slave zone from master results in connection refused

I’m using bind9 with webmin to try and set up a dns secondary for our primary nameserver. I’m in what I assume should be a very simple situation but I’m not able to get the master to transfer zones to the slave.

I’ve configured the master to have the slave in the Webmin Server Index then configured it as a slave under Cluster Slave Servers, then configured allow_transfer on the master with the ip of the slave. iptables -nL shows ports 53 and 953 as open on both master and slave. netstat -lnpt shows named listening to 53 (on master and slave), yet when I run test transferring the records to the slave I get:

Testing transfer of slave zone from .. .. from :  Failed : ;; Connection to for  test.example.com failed: connection refused. 

Configs for zone on master .2

zone "test.example.com" {   type master;   file "/var/lib/bind/test.example.com.hosts";   notify yes;   allow-transfer {;     }; }; 

Configs for zone on slave .3

zone "test.example.com" {   type slave;   masters {;     };   file "/var/lib/bind/test.example.com.hosts";   allow-transfer {;     };   allow-update {;     }; }; 

I know I’m missing something, but I can’t seem to figure it out.

Thanks for any help

How to view sophos antivirus scan results

I’m using sophos antivirus on the command line (sav-protect) on my Ubuntu 16.04. After running a scan, the software detected “28 errors” and “0 threats”. I wanted more information on the scan results, so I looked at the logs with sudo /opt/sophos-av/bin/savlog but the only entry corresponding to my scan was:

Mo 10 Jun 2019 19:21:19 CEST: savscan.log           On-demand scan started. Mo 10 Jun 2019 21:56:59 CEST: savscan.log           On-demand scan details: master boot records scanned: 0, boot records scanned: 0, files scanned: 375041, scan errors: 28, threats detected: 0, infected files detected: 0 Mo 10 Jun 2019 21:56:59 CEST: savscan.log           On-demand scan finished. 

Is there any way of getting more information on my scans? How do I get my hands on the errors detected to analyse and correct them?

The scan command I ran was this:

sudo savscan -sc -rec -dn -c -archive -pua -suspicious --stay-on-filesystem --stay-on-machine --backtrack-protection --preserve-backtrack --examine-x-bit --show-file-details /home/ 

Here are the details of the flags I’m using:

-sc = scan inside dynamically compressed files -rec = recursive down directories -dn = display names in form [mm:ss:filename] -c = ask for confirmaiton before disinfection/deletion -archive = scan inside archives -pua = scan for adware/potentially unwanted apps -suspicious = scan for suspicious files  

Google Scholar user profile has disappeared from search results

I have a public user profile on Google Scholar, and my user profile used to show up when I searched my name on Google Scholar. However, as of about two weeks ago, it no longer appears in the search results, although it still appears if I click “My Citations.” I double-checked that the profile is still public, and indeed, it even shows up on regular Google if I search my name.

How can I get my user profile to show up in the Google Scholar search results again?