Monday, February 4, 2013

Excel Lookup function - Search a name and show it's vaue

This article will explain what is Lookup function in Microsoft excel and how to use Lookup function with example.

LOOKUP function is a very useful function in Microsoft Excel which returns  a value from a range of values(a row or a column) or from an array.

There are two forms of the function.

1. Vector form
2. Array Form

1. Vector Form
-------------------

In this form, the function searches for the lookup_value in a range, i.e. a row or a column and when a match is found, it takes the corresponding result_value from another range specified (row or column).

Note: The data in lookup_range must be in sorted order. Otherwise Lookup function will give incorrect result.

Syntax:

=LOOKUP(lookup_value, lookup_range,[result_range])

result_range is optional.

Example:



Here are some more examples and the corresponding result:

=LOOKUP(104,A2:A5)              returns 104
=LOOKUP(103,A2:A5,B2:B5)     returns Binay

2. Array Form

The array form, the LOOKUP function searches for the value in the first row or column of the array and returns the corresponding value in the last row or column of the array.

Syntax:

=LOOKUP(lookup_value,array)

Example:

=LOOKUP("B", {"A","B","C","D";10,11,12,13})    returns 11 =LOOKUP("B", {"a","b","c","d";10,11,12,13})   returns 11
=LOOKUP("b", {"A","B","C","D";10,11,12,13})   returns 11
=LOOKUP("E", {"A","B","C","D";10,11,12,13})   returns 13
=LOOKUP("Back", {"A","B","C","D";10,11,12,13})   returns 11
=LOOKUP("0", {"A","B","C","D";10,11,12,13})   returns #N/A

For more Tips & Tricks in Excel, Click Here.

No comments:

Post a Comment

Please give your feedback, questions and suggestions. I will surely answer you.

Related Posts with Thumbnails

Labels

2012 (3) 2012-13 (1) Aakash tablet (1) Abhinav Bindra (1) Abhishek Bachhan (1) About Google Wave (1) account hacked (1) Actor (1) addthis (1) ads (2) Adsense (4) adsense and money making (4) Adsense check (1) adsense really pays (1) Adsense revenue sharing (1) Adsense revenue sharing sites (1) AIDS Awareness (1) AIDS Cure (1) AIDS Prevention (1) Airtel (1) Airtel Digital TV (1) Aishwarya Rai (1) al-qaeda (1) Allahabad Bank (1) alter command (2) alter table (2) american ascent (1) anchor tag in html (1) Another Google Innovation (1) anti-biotics (1) Anti-Virus (1) Arts (2) Atlanta Olympics (1) auto commit (1) awk command (1) Back up registry key (1) bacteria (1) Baithe Jeeto jackpot Question (23) Bajaj Allianz (1) Bajaj Allianz Home Insurance (1) Bank Clerical Exam (1) Bank PO Online Test (1) Banking jobs (1) BCECE (1) BCECE 2011 result (1) Beez 20 (1) best moments (1) Best Performing Ads (1) Bharti Airtel (1) Bhulekh (1) Bhulekh.ori.nic.in (1) big bazaar (1) Big Boss 5 (2) Big Boss 5 Contestants (2) Big Boss 5 House Inmates (2) Big Boss 5 Videos (1) Birth Day (1) blank space above table in blog (1) block a sender (3) Blog (1) Blog's Stats (1) Blogger Tips (17) Bluedart courier (1) BMI (1) Body Mass Index (1) Bollywood (2) bookmarks (1) Books (1) bronze (1) Browser (2) Bruce Jenner (1) BSE (1) bse odisha 2013 result (1) bseodisha.nic.in (1) BSNL (1) bulk (1) Cable Operator (1) call center (1) Campus interview (1) Causes and Prevention of Infant Diarrhea (1) cctv (1) celebration (1) celebrity (1) change mouse sensitivity (1) Chat messengers (1) Check Number for DND (1) cheque book (1) Cheque Fraud (1) Child Immunization chedule (1) Children Projects (1) chip tablet (1) Clear Browsing History (1) comment (1) Company Deposits (1) Compare auto insurance (1) Compare Strings (1) Computer Tips (45) Confident English (2) Crafts (2) create a batch file to delete files (1) create PDF (1) Credit Card (3) Credit Card issuers (1) credit card types (1) Credit Card usage (1) credit history (1) Cricket (4) Cricket Live score (2) criminals (1) Cron (2) Crowd (1) Currency conversion (1) custom domain (1) DC Avanti (2) DC Design (1) death (1) decathlon (1) Delhi Auto Expo 2012 (2) department of Telecom (1) disk partition (1) Distinct in Excel (2) DLL Definition (1) DLL File (1) dll or application file through gmail (1) DND (2) domain name (1) Domain names (2) domain redirection (1) Doodle (1) Door Chain (1) DOS Command (1) DoT India (1) dotnet interview questions (1) Download (1) Download movies online (1) download NCERT e-Books (1) download youtube videos (1) drop (1) drop multiple column (1) DropBox (2) DTH Service India (1) duplicate file (1) earn 100 dollars a day (1) earn 1000 dollars a day (1) Earn Money Online (4) earn online by creating rich content (1) earn through google adsense (3) Electricity Bill Payment online in Odisha (1) email (1) Email Extractor (1) email scavenger (1) email whitelist (1) EMS (1) engineering (1) English Grammar (1) eodissa (2) EPF India (1) EPF Online (1) Event (1) Excel 2007 (3) Excel Tips (4) expert answer (2) expert answer blog (2) expertanswer blog (9) expiry date of a LPG Gas cylinder (1) Express Parcle (1) facebook (4) Facts about AIDS (1) Family Budgeting (2) fathers day (1) fear and greed (1) File Sharing (2) filter (1) finance (19) Financial Decision (1) Financial Goal (1) financial planner (2) Find IP Address (1) Find IP of your computer (1) Fixed deposit (1) Flixya Alternatives (1) FloJo (1) Florence Griffith (1) Fluent English (1) Font Size (1) fontself (1) foreign clients (1) Fred Willard (1) Free Dotnet Projects (1) fresher (1) full snap shot (1) Gagan Narang (1) GAS Cylinder safety (1) gastroenteritis (1) gbjj (26) GBJJ Answer (25) GBJJ Question 2013 (25) GBJJ Question KBC 7 (2) get more from google search (1) get out of debt (1) get rich (1) Get Richer (1) Ghar Baithe Jeeto Jackpot (50) Ghar Baithe Jeeto jackpot Question (2) GIF Image (1) gmail (5) godaddy (3) Gold (1) Google (18) Google Adsense (3) Google Calculator (1) Google Chrome browser (1) Google Help Forum (1) google labs (1) google listing (1) google page rank (2) Google Search (2) google search tips (1) google tool (1) google transliteration (1) Google Wave (1) Govt Jobs (1) Govt of India (1) Gregorian calender (1) grep example (1) grep in linux (1) grep in unix (1) Gsm phone emergency call (1) Gymnastics (2) Hacking (1) Happy New Year 2016 (1) Happy teachers day (1) HDFC Standard Life (1) health insurance (1) Health Tips (5) Hit Counter (2) Hollywood (1) Home insurance in India (1) Home Safety Tips (1) HostGator (3) hosting (3) hotmail (1) How much we can earn through Google Adsense (1) how to (1) How to make an emergency call from mobile phone (1) how to send exe file with gmail (1) how to show odia text in bhulekh (1) href (1) HSBC (1) HSBC Home Insurance (1) HTML (2) HTML Symbols (1) IANA (1) ibnlive (1) ICC World Cup 2011 final match (1) ICC World cup final (1) ICC World cup final pics (2) ICC World cup semifinal schedule (1) ICICI Lombard (2) IE8 (2) IIS (1) images (1) images not displaying in gmail (1) imint (1) immunizational chart (1) income tax slab (1) Increase google rank (1) Increase Traffic to Blog (1) Increase your website popularity (1) India (8) India Immunization Chart (1) India Spells 2009 Champion (1) Indian Premier League (1) Indian States (1) Indian Super car (2) Information (1) Infosys (1) ini file (1) insurance (1) Internet (13) internet calculator (1) Internet Explorer (1) Internet Explorer provided by (1) Internet Explorer provided by Dell (1) Internet Protocol (1) Internet Speed (1) Investment (10) investment option (1) investor (1) IP of your machine (1) IP of your PC (1) IPL (4) IPL Teams (1) ixwebhosting (1) Jackpot question today (32) Job Portals (1) Job seekers (1) Job Sites (1) joomla (1) joomla 2.5 (1) Joomla hosting (4) June 19 (1) Karnam Malleswari (1) KBC 5 (22) KBC 6 (28) KBC GBJJ Winner (25) KBC Online (25) KBC Sony (19) keepvid (1) killed (1) know your bandwidth (1) kontera (1) large whitespace in my blog (1) Leap Year (1) learn (2) Learn proper pronunciation of english words (1) Learning (1) licence key (1) linkwithin (1) lipikar (1) Login (1) London Olympics (6) London Olympics logo (1) Long term investor (2) long URL (1) lower (1) Mail signature (2) make emergency phone call (1) Mary Lou Retton (1) MCA (1) Medal Count (1) mediclaim policy (1) Mental Accounting (1) menu item (1) merriam webster dictionary (1) Merry Christma (1) mGinger (1) Michael Johnson (1) Microsoft (3) Microsoft name.dll (1) Microsoft Virtual PC (4) mobile Bill (1) mobile emergency response support (1) mobile number (1) Mobile number change to 11 digits in India (1) mobile phone emergency number (1) money management (1) Money Mistake (1) most viewed (1) mouse pointer (1) mouse sensitivity (1) mouse speed (1) Mozilla (1) msi.dll (1) MSN Messenger (1) mutual fund (2) Mutual fund ELSS (1) Mutual Funds (2) Nadia Comaneci (1) national anthem of India (1) National immunization schedule (1) ncert website (1) NDM-1 (1) New York (1) Newly weds (1) NSE (1) Nylon Rose (1) obama speech (1) Obese (1) Odia Calender 2010 (1) odia font not displaying (1) odia literature (1) odia magazine (1) Odia Panji (1) Odia panjika (1) odisha board 10th result (1) Olympics (8) Olympics 2012 (3) online frauds (1) Online Security (1) Online Test (2) Opera Browser (1) Operating System (5) optimize google search (1) Oracle (8) Origami (2) Orissa Online (1) Oriya calender (1) oriya magazine (1) oriya poems (1) oriya stories (1) Orphan file (1) Orphaned file finder (1) ORS (1) Osama bin Laden (2) Over weight (1) own handwriting (1) Page Title (1) Page view (1) Paraskevi Papachristou (1) Partition magic (1) partition wizard (1) payback (1) Payment (1) PeepHole (1) Pentagon (1) Personal Finance (17) PF transfer (1) PF Withdrawal (1) Phishing Scams (1) photo (1) PhotoBucket (1) phpbb (1) PIN Code (1) PING (1) post a comment problem in blogger (1) Postal Index Number (1) pound in indian rupees (1) Pound in rupees (1) pound to rupee (1) pound to rupee conversion (1) prefix 9 with all mobile numbers (1) President Obama speech (1) primary key (4) Prince William and Kate Middleton Wedding (2) print as PDF (1) print screen (1) productivity tool (1) Puzzles (1) question 4 kbc blogspot (19) quick install (1) QuickInstall (1) Quilling (1) Rabindranath Tagore (1) Rajesh Khanna (1) read ncert books online (1) Read SMS (1) Real Estate (1) Really Tough Movie Quiz (1) Received 100$ from google adsense (1) Received my first google adsense cheque (1) recover gmail account (1) related posts in blog (1) Reliance Big TV (1) Reliance India (1) remove mother tongue influence (1) remove SQM files from computer (1) remove white space in blogspot (1) Retire Early (2) retire sooner (1) retirement (2) Retirement Planning (1) Return to Buckingham Palace (1) reward points (1) RIP (1) RockMelt (1) Ronjan Sodhi (1) Royal Couple (1) Royal Wedding (2) Royal Wedding Kiss Video (1) Royal Wedding Pictures (1) Rupee Symbol (1) safe banking (1) safe online (1) safety (1) sarvapalli radhakrishnan (1) save money (2) Save password (1) savevid (1) Schedule (1) Screen capture software (1) scrolling web page (1) Search engine spider (1) Security (1) See through Hole (1) sell mutual fund (1) Send SMS to KBC (20) Senior Citizens (1) Seo (9) Service Pack (1) set nameserver (1) share file publicly (1) Shooting (1) Show Desktop (2) Show Line Numbers (1) simulator (1) SIP (1) Site Statstics (1) Slow Internet Connection (1) SMS Tracking (1) Social networking sites (1) Software Product (1) sony kbc (19) sp (1) spam (1) speak influential english (1) Speed Post (1) Spell Bee Contest (1) spend smartly (3) spend wisely (2) Spoken English (1) Spouse (1) sql developer (1) SQL Server (3) sqlldr example (1) States in India (1) stay out of debt (1) Stock market (6) Stock Tips (3) subdomain (1) Submit to google (1) Submit to msn (1) Submit to yahoo (1) Submit your website or blog to major search engines (1) Submit your website to Google (1) substring (1) Sun Direct (1) Super Bug (1) Survey (1) Synchronizing (1) Tata Sky (1) Tax Planning (1) technology (2) Telecom (2) Telecom service (1) telecom service in India (1) terrorist (2) text advertisements (1) Thanksgiving (1) The Balcony Kiss Video (2) THE GOLDEN SHOES (1) The New India Assurance (1) time zone (1) TNSPING command (1) Todays GBJJ Question Of KBC 7 (25) top 10 tips (1) Top DTH Services in India (1) Top ten (2) Top ten Telecom service providers (1) Track Online (1) track your Speed Post (1) tracking (1) Trading (1) traffic to blog website (1) TRAI (1) twitter (2) under weight (1) UNICEF (1) Union Territories (1) United India Insurance (1) unix commands (1) Unix Tips (3) upper (1) URL Shortener (1) Urszula Radwanska (1) Use forums (1) use google search effectively (1) Vaccination schedule in India (1) Vedic maths (1) vedic science (1) Verbs (1) Version Control Tools (1) Videocon D2H (1) Visual Studio (1) watch movies online (1) Water Polo (1) wealth management (1) Web site page rank (1) Web technology (4) website (3) Wedding Pics (1) What are .SQM files (1) What is Google Adsense (1) when to use Google Wave (1) why google adsense (1) Why my site not coming in google (1) Will and Kate (1) Windows 7 (2) Windows Live (1) Windows Live Messenger (1) windows OS (2) Women (1) wordpress (1) World AIDS Day 2009 (1) World Trade Centre (1) WPA_KILL (1) write in Odia (1) write in web (1) Yahoo (3) Yahoo answers (1) yahoo mail (1) yahoo rank (1) youtube video (2) youtube video download (1)

  © Blogger templates Palm by Ourblogtemplates.com 2008

Back to TOP