In this Excel tutorial you will learn , How to Use the Reverse VLOOKUP Formula to Look Up Values in a Table
The VLOOKUP function in Excel is used to search for a specific value in a table or range and return a corresponding value from another column in the same row. However, sometimes you may need to do the reverse, i.e., search for a value in a column and return the corresponding value from another column in the same row. This is where the reverse VLOOKUP formula comes in.
The syntax for the reverse VLOOKUP formula is:
=VLOOKUP(lookup_value, table_array, col_index_number, [range_lookup])
In this formula, the lookup_value is the value we want to search for in a column, table_array is the range of cells that contains the data, col_index_number is the number of the column in the table that contains the value you want to return, and range_lookup is an optional argument that specifies whether to do an exact or approximate match.
To use the reverse VLOOKUP formula, you need to switch the positions of the lookup_value and col_index_number arguments in the VLOOKUP formula. This means that you would be looking for a value in a column, and returning a value from another column in the same row.
For example, if you have a table with employee names and their corresponding employee IDs, and you want to search for an employee ID and return the corresponding employee name, you can use the reverse VLOOKUP formula like this:
Formula : VLOOKUP(B3,CHOOSE({1,2},F6:F11,B6:B11),2,FALSE)
#excel #Reverse_vlookup #vlookup #accounting #learning_center #accounting_software
ags for micrsoft Excel formula
Microsoft Excel
Formulas
Functions
Calculation
Spreadsheets
Data analysis
Conditional formatting
VLOOKUP
Pivot tables
SUMIF
IF function
INDEX-MATCH
Data validation
Macros
Charts and graphs
Array formulas
DATE and TIME functions
Statistical functions
Financial functions
Lookup and reference functions
.
Ещё видео!