SOLVED

I'm using vlookup the way I always do, but this time it's not working.

Copper Contributor

Robert_Wasiuk_2-1709924160393.png

 

 

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?

2 Replies
best response confirmed by Robert_Wasiuk (Copper Contributor)
Solution

@Robert_Wasiuk 

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!
1 best response

Accepted Solutions
best response confirmed by Robert_Wasiuk (Copper Contributor)
Solution

@Robert_Wasiuk 

Check whether there is a space after Alternative Baking Company on one of the sheets but not on the other.

View solution in original post