Hi all,
New member here and I have a problem in this formula =VLOOKUP(I952,SourceData4!$A$2:$K$150,2,FALSE). The contents of cell I 952 is itself a concatenated 5 digit number. Returns a #NA error. If, however, I enter the 5 digit number instead of allowing it to be concatenated, the Vlookup function works correctly.
Any ideas? all cells have been formatted as numbers.
Roy