Vlookup won't see a number unless I press F2 and Enter

[usnapoleon]

Hi all
I have a Vlookup formula that is functioning correctly, but it requires stupid actions on my part.

The stupid part is that I have to go into each cell in column T, press F2 to edit, then press enter. THEN the Vlookup in column Z will display the actual number. I'm not actually editing anything in Column T. But that is what I have to do. Anyone know why?

 

[usnapoleon]

Oh, I should also add that the data above is copied from another spreadsheet, exact copy/paste of the data

 

[MARK858]

Looks like Column T are numbers stored as text, column D is probably real numbers.
If none of the numbers start with 0 try (on a copy of your sheet) selecting column T then

• Data tab
• Text to Columns
• Delimited
• Next
• Make sure all the checkboxes are cleared
• Click Finish

 

[usnapoleon]

It is stored as a Text, stupid thing. I was looking at the formatting and it wasnt standing out to me. I wonder why it's like that. I'll dig deeper, but at least it would be an easier fix each time I work on this. Thank you!

 

[MARK858]

You're welcome

 

[Peter_SSs]

but at least it would be an easier fix each time I work on this.

If you don't want to have to do the Text to Columns every time, try just changing your column Z formula to

=VLOOKUP(--T411,'2024 Gift Cert Balances'!D:D,1,0)