KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
After checking if a cell value exists in a column, I need to get the value of the cell next to the matching cell . For instance, I check if the value in cell A1 exists in column B , and assuming it matches B5 , then I want the value in cell C5 . To solve the first half of the problem, I did this... =IF(ISERROR(MATCH(A1,B:B, 0)), "No Match", "Match") ...and it worked. Then, thanks to an earlier answer on SO , I was also able to obtain the row number of the matching cell: =IF(ISERROR(MATCH(A1,B:B, 0)), "No Match", "Match on Row " & MATCH(A1,B:B, 0)) So naturally, to get the value of the next cell, I tried... =IF(ISERROR(MATCH(A1,B:B, 0)), "No Match", C&MATCH(A1,B:B, 0)) ...and it doesn't work. What am I missing? How do I append the column number to the row number returned to achieve the desired result?
Tags (comma-separated)
Save Edits
Cancel