Forum Discussion
Solved
I'm using vlookup the way I always do, but this time it's not working.
I want the "Terms" column of the table on the left to say what the "B" column of the range on the right says on rows where its "A" column says what the left table's "Company Name" column says. I'm displaying the formula in the formula bar of the left table and selecting via window the name of the range on the right.
BUT
You can see that my "IFNA()" thing is being triggered.
I don't get it. I've done it this exact way with success. Can anyone see what I'm missing?
Check whether there is a space after Alternative Baking Company on one of the sheets but not on the other.
Check whether there is a space after Alternative Baking Company on one of the sheets but not on the other.
- Oh my god it WAS the space thing. Don't know why I didn't check. Thanks Hans!
