Forum Discussion
Help with VLOOKUP on different worksheets
I need help using the VLOOKUP formula. I have a source data worksheet Columns A,B,C are Product Code, Product Description, Product Cost respectively. In the next worksheet I have a table with the sa...
Your values in [CODE] Named Range = 'MasterCostData' are stored as Text. The data entry in $A$2 is General however, the value 110161 is understood to be Number.
Therefore, 110161 <> '110161'.