dcarbajal2006
New Member
- Joined
- Jan 19, 2018
- Messages
- 6
I am trying to use the index match function below to find a value. The values in the range Sheet2!F2:F6 are all characters but one. When the value of BODYMATRL is a character, the function works but when the value is a number it gives me an N/A error. Please help.
INDEX(Sheet2!G2:G3,MATCH(BODYMATRL,Sheet2!F2:F3,0))
INDEX(Sheet2!G2:G3,MATCH(BODYMATRL,Sheet2!F2:F3,0))