I have a formula using a lookup array that works if I reference the actual data I am looking for e.g. "12345678" but not if i reference a cell C12 that contains that data. Obviously I need it to look at a cell then go and check the array for a match and cannot enter the data manually.
Any help please?
Bookmarks