Quote:
Originally Posted by Mazzaropi
Try to use this one at: 'Look-up Sheet' D4
Before: =INDEX('H-DATA'!C2: D300,MATCH('Look-up Sheet'!F2,'H-DATA'!D2: D300,0),1)
Now...: =INDEX('H-DATA'!C2: D300,MATCH(TEXT('Look-up Sheet'!F2,0),'H-DATA'!D2: D300,0),1)
Tell me if it worked for you.
Have a nice Day.
|
Worked perfectly. I had a similar problem with another formula in this workbook that was solved by using the properties of the cells menu to change the format from number to text. I tried that in this scenario as well and kept getting the #N/A error.
Why would that not work in this instance and require the formula to format the data?