I have an Excel workbook of two sheets (Sheet A and Sheet B). I am using a value in Sheet A as the lookup value to return a value from Sheet B. Although the value exists in Sheet B, it returns a #N/A result.
I'm assuming this may be because there is a type mismatch between the lookup value (Text) and the lookup range (General).
How do I create a VBA macro to run through the Sheet A column to convert the cells from Text to General ?
Thanks in anticipation