DRandles
Reputation: 13
Excel Formula If a value matches a value in a range of cells then return corresponding value in a different cell
I am trying to get excel to take a job code from sheet 1
Compare it to a list of job codes & their respective salary grades on sheet 2
And if the job codes match, take that respective salary grade value (from sheet 2) and put it in column B (Salary Grade) of Sheet 1
I've tried a few different IF formulas and just can't get it to work out!
Really appreciate any help out there, thanks in advance!
Upvotes: 1
Views: 7213
Answers (1)
Scott Craner
Reputation: 152450
Put this in B2 and copy down:
=VLOOKUP(A2,Sheet2!A:B,2,FALSE)
Upvotes: 1
Related Questions
- Excel formula to return value based on cell value within a range
- Compare a cell to a range of cells in a workbook and set the result as another range of cells
- Match cell value to data in another column and return adjasent value to another cell
- Matching cell from two values
- IF Values match return true
- How to compare to cells and return a particular cell value in the matched row in Excel
- Compare cell to range of cells
- Comparing column to specific value, returns the value of other column to another column
- Excel: Evaluate an expression if a cell in a range matches another cell
- Excel Formula for Matching Cells