How to Use Lookup Value in Excel

August 9, 2022
735 Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

While working on excel with lots of data, some times you want to lookup if a certain value exists in a range of data. This might seem a simple task when your range is small and you can lookup manually that whether the required value exists in range. But when you have a large amount of data and are required to Look up value in excel WPS (2016/2019/mac/online) then it becomes a very tough task and it might take you ages to perform this task. Luckily there are different shortcuts possible in excel to find if a value exists in range in excel.

This article covers different shortcut methods in excel to Look up value in excel WPS (2016/2019/mac/online). Once you go through this article you will be able to easily Look up value in excel.


Three different shortcut ways of looking up a value in excel.


Using COUNTIF function to lookup a value in excel

Among different ways to check if a value exists in excel data the first methods is using COUNTIF function. You can use COUNTIF formula to see if a value exists in excel by following simple below mentioned steps and picture illustrations.

Steps:

1.Open WPS Excel /Spreadsheet file where you want to lookup a value in excel.

2.Click on the cell where you want your output to reflect whether a value exists in Excel.

3.Type “=COUNTIF” and press Tab.

4.COUNTIF Function will be initiated.

5.You need to enter two parameters in this function 

  • Range (Range in which which you want to lookup if a value exists in it)

  • Criteria (Here you enter the lookup value inside inverted commas I.e. “xyz”)Then you press enter.This function will return the exact number of times the required lookup value exists in the selected range.

Using COUNTIF embedded in IF function to lookup a value in excel

Another way of looking up if a value exists in range is by using a COUNTIF function embedded in IF function. You can use this method to see if a value exists in a range by following simple below mentioned steps and picture illustrations.

Steps:

1.Open WPS Excel /Spreadsheet file where you want to lookup if a value exists in excel.

2.Click on the cell where you want your output to reflect whether a value exists in excel.

3.Type “=IF(COUNTIF” and press Tab.IF Function with embedded COUNTIF Function will be initiated.

4.You need to enter four parameters in this function

  • Range (Range in which which you want to lookup if a value exists in it)

  • Criteria (Here you enter the lookup value inside inverted commas I.e. “xyz”)

  • Value IF True (You can use “Yes” here)

  • Value IF False (You can use “No” here)

6.Then you press enter.This function will return whether a value exists in a range in simple yes or no terms instead of exact number of time as shown section 1.1.

Using MATCH Function embedded in ISNUMBER function to lookup a value in excel

Another method of looking up if a value exists in excel is to use MATCH Function Embedded in ISNUMBER function.

Steps:

1.Open WPS Excel /Spreadsheet file where you want to lookup if a value exists in excel.

2.Click on the cell where you want your output to reflect whether a value exists in excel.Type “=ISNUMBER(MATCH” and press Tab.ISNUMBER Function with embedded MATCH Function will be initiated.

3.You need to enter three parameters in this function

  • Lookup Value  (value that needs to be looked up in a excel)

  • Look Up Array (range in which the lookup value is to be checked)

  • Match Type (This must be set to 0 to search for an exact match)

4.Then you press enter.This function will return whether a value exists in a range in simple True or False terms instead of exact number of time as shown section 1.1.


This article has covered the three different shortcut ways to lookup a value in excel.

Hopefully you have learned How to Lookup value in excel WPS (2016/2019/mac/online) ?  If you want to know more about Excel features, you can follow WPS Academy to learn.
You can also download WPS Office to edit the word documents, excel, and PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience.