Dancorkery26
New Member
- Joined
- Mar 22, 2020
- Messages
- 15
- Office Version
- 2016
- Platform
- Windows
Hi,
This is my first post on this forum. I have come across an unusual issue with excel. I am out of ideas!
Would really appreciate help with this.
Problem
I create a leftmost column to use for Vlookup. It contains =LotID&Unique ID formula. This is contained in sheet 1.
Sheet 2: The leftmost column in sheet 2 is ='sheet1'!A:A.
I then perform vlookup to drop detail into specific columns.
99% of the time the data is pulled without a problem.
For some reason occasionally it doesnt pull the information. The detail is there, I can clearly see it.
One thing I have noticed, when I do ctrl+F and try search for it sometimes it does not return.
I have attached a reduced example. Here you can clearly see the issue.
This is my first post on this forum. I have come across an unusual issue with excel. I am out of ideas!
Would really appreciate help with this.
Problem
I create a leftmost column to use for Vlookup. It contains =LotID&Unique ID formula. This is contained in sheet 1.
Sheet 2: The leftmost column in sheet 2 is ='sheet1'!A:A.
I then perform vlookup to drop detail into specific columns.
99% of the time the data is pulled without a problem.
For some reason occasionally it doesnt pull the information. The detail is there, I can clearly see it.
One thing I have noticed, when I do ctrl+F and try search for it sometimes it does not return.
I have attached a reduced example. Here you can clearly see the issue.