hooper12345
New Member
- Joined
- May 12, 2015
- Messages
- 36
Hi all,
My research on this topic has only really turned up vlookup which I don't believe that is what I'm after but could be wrong if someone broke it down as to why it would work best. Any way, I have my first workbook called 'barcodes' and the column of interest is K. My second workbook is 'dept data' with column F. Basically those two columns have the same number that I'm using to validate the item with. (New vs Old). Is there a simple way for me to highlight in 'dept data' when the number is also in 'barcodes'?
Thanks again.
My research on this topic has only really turned up vlookup which I don't believe that is what I'm after but could be wrong if someone broke it down as to why it would work best. Any way, I have my first workbook called 'barcodes' and the column of interest is K. My second workbook is 'dept data' with column F. Basically those two columns have the same number that I'm using to validate the item with. (New vs Old). Is there a simple way for me to highlight in 'dept data' when the number is also in 'barcodes'?
Thanks again.