Sunday, March 22, 2020

Janta Curfew on 22nd Mar 2020 from 7am to 9pm.

Prime Minister of India announce the one day Junta Curfew on 22nd Mar 2020 from 7am to 9pm.

On 22nd March at 5pm come out on their balconies and terraces and show their gratitude towards people who are delivering essential services for 5 minutes.

World Health Organisation Whatsapp contact and link

World Health Organisation Whatsapp contact and link
  • Open WhatsApp on your phone.
  • Tap on this link and send join to WHO WhatsApp group to received update regarding COVID-19.
  • Alternatively, you can add +41 79 893 18 92 number to your contact, and chat with WHO Coronavirous pandemic.

Thursday, January 9, 2020

Reverse or Backward Vlookup in Microsoft Excel

Reverse or Backward Vlookup in Microsoft Excel


Following is the data format we have.

  • We will use VLOOKUP and CHOOSE function.
  • In cell F2 formula
  • =VLOOKUP(E2,CHOOSE({1,2},C2:C5,A2:A5),2,FALSE)

Data format