13. Enter a formula in cell M7 using the VLOOKUP function to find an exact match for the department abbreviation. Look up the department abbreviation (cell M6) using an absolute reference, search the staff table data (the range A6:J13) using an absolute reference, and return the department name (the 2nd column).
The formula in cell M7 using the VLOOKUP function to find an exact match for the department abbreviation. Look up the department abbreviation (cell M6) using an absolute reference, search the staff table data (the range A6:J13) using an absolute reference, and return the department name (the 2nd column) :
M7=VLOOKUP( $M$6, $A$6:$J$13, 2, FALSE )
VLOOKUP takes as inputs :
1. The value to be matched - Here we use absolute reference for the cell M6
2. The table array range to look for the value - Here we use absolute reference for the staff table (the range A6:J13)
3 -The column value to returns - Here we are returning the department name (2nd column)
4 -Exact or Approximate match - Here we use Exact match (FALSE)
VLOOKUP search for the exact value in cell M6 in the first column of the table , A6:J13 and returns the 2nd column value for the matched row and store in M7.
Get Answers For Free
Most questions answered within 1 hours.