In the enclosed, I want the profit sheet column B to show the column C value from refsources. It could also reference column A from refsources but I thought Vlookup values need to be to the right of the column array you are searching for a match within. However it shows Err:502 currently in Libreoffice. In Excel2016 shows #N/A or #REF! If you change the index to 1 it shows the last name however.
I was working on this file in Libreoffice. The data is originally pulled from a 3rd party software and my suspicion is the issue is the way the data imports is not properly formatted (i.e. text instead of strings instead numbers or similar). I suspect some trick that I cant figure out needs to be employed to ensure all the data is in proper formats....
Bookmarks