Hey guys,
I have roughly 30 sheets of data and I am looking to match values from one sheet to a range in another sheet and then return the value in a separate column of the same row.
Example:
- On Sheet1 I have a range of names (A2:A2000) and range of associated email addresses (AF2:AF2000)
- On Sheet5 I have a list of names (starting with A2)
- I want to add a formula in a column that takes the name in Sheet5!A2, finds the match in Sheet1!A2:A2000 and then returns the associated email address from Sheet1!AF2:AF2000
I have tried a few different formulas, however, I can't seem to make one that fits the needs:
Currently, Sheet5!A2 is matched to Sheet1!A756, so I need to return the value of Sheet1!AF756
Bookmarks