Cell format & formula

Occasional Visitor

I need help with something. I am trying to do vlookup forumula and some of the cells pulled the correct info over and some have not. I was trying to make sure all the data was formatted correctly and sorted right to eliminate possibilities for why its not pulling the info over. And I found an issue that might be the problem. 


Sheet 1 has Invoice info with check information. The first column is the Invoice#.

Sheet 2 has invoice info withOUT the check info. The first column is the Invoice#

I'm trying to pull the check info over to sheet 2. 

So I sorted each sheet by Invoice#

On Sheet 1 when I click on Sort, it comes up Alphabetical sort (A-Z)

On Sheet 2 it wants to sort Numerically (Largest to smallest)


Obviously the first thing i did was try to change the format of that column but it doesn't work. I change the format but when I go to sort, it says the same thing. I'm guessing this is why my vlookup isn't working right. I tried changing the format for both sheets to "GENERAL", I tried TEXT, I tried several things. But one sheet wants to sort one way and the other sorts another way. 


I tried copying the info and pasting the values without formatting to another sheet. 


please help!

2 Replies


Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.


In general VLOOKUP or any other lookup function shall work if you have both text or both number for the Invoice #. Soring doesn't matter. Perhaps you may provide small sample file?