SuperLute58
New Member
- Joined
- Jan 23, 2014
- Messages
- 6
So I have the formula written exactly how it's worked many other times.
=VLOOKUP(B3, Sheet2!A:B, 2, FALSE)
I have found the value of B3 on Sheet2. I know it exists. I found it using the find feature. I have Sheet 2 sorted. Both Column B on my formula page and the Sheet2 column are are formatted the same. My table array is correctly aligned. However it's pulling back #N/A.
Please save the life of my computer so I don't have to cause it harm.
=VLOOKUP(B3, Sheet2!A:B, 2, FALSE)
I have found the value of B3 on Sheet2. I know it exists. I found it using the find feature. I have Sheet 2 sorted. Both Column B on my formula page and the Sheet2 column are are formatted the same. My table array is correctly aligned. However it's pulling back #N/A.
Please save the life of my computer so I don't have to cause it harm.