How to use lookup formula in excel explain with #example.

 In this video explain Lookups which is given below

1. lookup 2. V-lookup 3. H-lookup
Hi, I’m Divyesh, a passionate technology and automation expert dedicated to building smart, scalable, and efficient solutions. With a strong background in MIS, software development, and AI-driven automation, I specialize in optimizing workflows, streamlining business operations, and leveraging data for better decision-making.

Comments

Post a Comment

Popular posts from this blog

CodeIgniter 4 Filters - Complete Guide

CodeIgniter 4 Filters: A Complete Guide Filters in CodeIgniter 4 allow you to process HTTP requests before reaching the controller and responses before being sent to the client. What are Filters in CodeIgniter? Filters act as middleware and help in: ✅ Authentication & Authorization ✅ Input Validation ✅ Logging & Monitoring ✅ CORS (Cross-Origin Resource Sharing) ✅ Custom Request Handling How to Create and Use Filters? Step 1: Create a Filter Navigate to app/Filters/ and create a new file AuthFilter.php : namespace App\Filters; use CodeIgniter\HTTP\RequestInterface; use CodeIgniter\HTTP\ResponseInterface; use CodeIgniter\Filters\FilterInterface; class AuthFilter implements FilterInterface { public function before(RequestInterface $request, $arguments = null) { if (!session()->get('logged_in')) { return redirect()->to('/login'...
Read more

Automate Your Hiring Process with Google Sheets – The Smart Recruitment Tracker by Excel Walaa

Managing recruitment manually can be time-consuming. Screening resumes, scheduling interviews, and sending offer letters require hours of effort. At Excel Walaa by Divyesh , we focus on automation to simplify hiring. The Smart Recruitment Tracker is a fully automated Google Sheets system that streamlines hiring from job applications to final selection. What is the Smart Recruitment Tracker? The Smart Recruitment Tracker is an end-to-end hiring automation tool built in Google Sheets , eliminating the need for expensive HR software. It automates every stage of recruitment, helping businesses make hiring more efficient. Collects job applications from Google Forms Shortlists candidates based on predefined criteria Schedules interviews and generates Google Meet links Sends interview invitations and evaluation forms automatically Calculates interview scores and determines final selection Generates personalized offer letters in Google Docs and sends them via email Provides a real-tim...
Read more

CSS Animations and Transitions

Image
  Bringing Your Web Pages to Life: CSS Animations and Transitions Hello again, web enthusiasts! After mastering HTML and the basics of CSS, including responsive layouts, it’s time to add another layer of sophistication to your web designs. In this blog, we're going to dive into the world of CSS animations and transitions, powerful tools that can bring your web pages to life with dynamic, interactive elements. Understanding CSS Transitions CSS transitions allow you to change property values smoothly over a specified duration. Basic Syntax of a CSS Transition: css transition : property duration timing-function delay; Property : The CSS property you want to apply the transition to. Duration : How long the transition takes. Timing-function : The speed curve of the transition. Delay : The time before the transition starts. Example of a CSS Transition: css .button { background-color : blue; transition : background-color 0.5s ease; } .button :hover { background-color : green; } ...
Read more