Caly
Board Regular
- Joined
- Jul 19, 2015
- Messages
- 159
- Office Version
- 365
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
Hi I need to see if a cell matches another cell to bring in data associated with it. I’m trying to see if column a row 1 says something to see if it is in that range of data and if yes return the associated data but if not then say no data. How can I write the formula to show that? I’m trying this but it shows #n/a if there is no match.
Column A. Column B
T-shirt. Red
Shoes. Blue
Next tab has the summary to input and I’m using the formula to enter in column B:
=if(vlookup(A2,data range from other tab $A$1:$B$2,2,0)<>A2,”No match”,
vlookup(A2,data range from other tab $A$1:$B$2,2,0)
Column A. Column B (formula)
Name. Result
T-shirt. Red
Purse. No match
Column A. Column B
T-shirt. Red
Shoes. Blue
Next tab has the summary to input and I’m using the formula to enter in column B:
=if(vlookup(A2,data range from other tab $A$1:$B$2,2,0)<>A2,”No match”,
vlookup(A2,data range from other tab $A$1:$B$2,2,0)
Column A. Column B (formula)
Name. Result
T-shirt. Red
Purse. No match
Last edited: