MixedUpExcel
Board Regular
- Joined
- Apr 7, 2015
- Messages
- 222
- Office Version
- 365
- Platform
- Windows
Hi All,
I have 2 formula's in 2 cells.
Cell 1 - is using iferror / index / match (concatenate)
Cell 2 - is a vlookup
Cell 1 returns the value (text) that I am expecting
Cell 2 returns a 0 when I am using the Cell 1 as the criteria for the lookup (this is not the correct result)
As I have confirmed Cell 1 with SHIFT + CTRL + ENTER, I'm assuming that the vlookup can't use the array as a criteria? or at least without something else in there to help.
Can anyone tell me how this is usually fixed so that result is correct and not 0?
Thanks.
Simon
I have 2 formula's in 2 cells.
Cell 1 - is using iferror / index / match (concatenate)
Cell 2 - is a vlookup
Cell 1 returns the value (text) that I am expecting
Cell 2 returns a 0 when I am using the Cell 1 as the criteria for the lookup (this is not the correct result)
As I have confirmed Cell 1 with SHIFT + CTRL + ENTER, I'm assuming that the vlookup can't use the array as a criteria? or at least without something else in there to help.
Can anyone tell me how this is usually fixed so that result is correct and not 0?
Thanks.
Simon