How to use lookup in excel

July 26, 2022
728 Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

Excel's lookup functions involve referencing a cell in order to retrieve the relevant results from other rows and columns by matching values in another row or column against the cell in question. This is accomplished by matching values in another row or column against the cell in question. It makes your assignment very easy if you know that how to use lookup in excel.

WPS Excel provides us with the opportunity to make use of it as a spreadsheet function. This article will walk you through the fundamentals that how to use lookup in excel and present various examples for you to consider when deciding which Lookup function is most appropriate for a given set of circumstances.

How To Use Lookup in Excel?

Let's say we are interested in the grades of the students who are ranked 1, 3, 5, and 7. We want to know that student with list number 1, 3 and 7 have how many numbers.

1. Launch WPS Spreadsheets and navigate to the any cell where you want results in your table. And put the list numbers of students for against them you want results. Now select cell against number 1 to put the lookup formula to get the result.

2. Now put the formula put the = sign type lookup and (bracket and now put cell which have the value against you want result as D9 cell have the value number 1 and we want the result against number 1. Next after putting comma select the range which you want to lookup to get the result and type bracket close sign ) and hit enter.

3. As we hit the enter, we have the result math against the number 1 b as it is against the cell A1.

4. Now move the cursor to the lower right corner of the cell in which you have the result and when cross sign in black color will appear click and drag below where you want other result you will get the result against the other number as well.

How To Use Lookup in Excel: HLOOKUP

Now suppose we are interested in getting the result of a student name john, in Math subject. HLOOKUP function lookup for result against two value column and row together. As we have two value name john and subject math.

1. Launch WPS Spreadsheets and navigate to the any cell where you want results in your table. And put the list numbers of students for against them you want results. Now select cell against number 1 to put the lookup formula to get the result.

2. Now click on lookup and reference option and select the HLOOKUP From the list. And click on HLOOKUP.

3. Once you click on HLOOKUP the function argument window will open. lookup value is john C1

Table array the whole data A1:F5

Row num is 2

Type false in range lookup and click OK.

4. As you hit OK the result is ready.

This article offers a comprehensive and step-by-step guide that explains how to use lookup function in Excel to compute a solution to a problem in order to achieve the desired result.

If you would want additional information regarding the WPS office, please refer to the webpage for the WPS Academy. You can also edit documents that are saved in Word, Excel, PowerPoint, or PDF format by downloading WPS Office from this website. WPS Office is available as a free download.