Generally, the VLOOKUP function will help to look up the value from a table by a row. In this guide, we will discuss how to find a Two-way lookup in Excel by using the VLOOKUP function? Let’s get started!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
Generic Formula:
- To find the two-way lookup, you can use the below formula in Excel.
=VLOOKUP(lookup_value,table,MATCH(column_name,column_headers,0),0)
Syntax Explanations:
- VLOOKUP – In Excel, the VLOOKUP function will help to lookup data in a range or table by row.
- MATCH – This function helps to locate the position of a lookup value in a row, column, or table. Read more on the MATCH function.
- Lookup_Value -It represents the criteria that you want to be found.
- Table – It is the input data from your worksheet.
- Comma symbol (,) – It is a separator that helps to separate a list of values.
- Parenthesis () – The main purpose of this symbol is to group the elements.
Practical Example:
Refer to the below example. Here, we will show how to find the two-way lookup in Excel
- First, we will give the input values in Column B to Column E.
- Then enter the given formula into the formula bar section.
- Finally, we will get the result in the selected cell.
Wrap-Up:
In this short tutorial, we have described the simple formula used to find the two-way lookup in Excel by using the VLOOKUP function. If you feel this article is helpful then leave feedback in the below comment box. Thank you so much for visiting our site!! Click here to know more about *Geek Excel **and Excel Formulas *!! **
Top comments (0)