SOLVED

VLOOKUP

Copper Contributor

Hello, I have a problem with the VLOOKUP formula. 
At my work I use VLOOKUP a lot, and one day it just stopped working. To VLOOKUP to work I need to do “convert to number”, but that little error button I press to do “convert to number” has just stopped appearing, so I can’t convert to number. 
Please help me!!! 

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

Hi @Shir033 ,

 

you could check the Excel options, maybe one of these options have been switched off:

DTE_0-1649324827931.png

 

@Martin_Weiss Thank you so much!!

 

 

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

Hi @Shir033 ,

 

you could check the Excel options, maybe one of these options have been switched off:

DTE_0-1649324827931.png

 

View solution in original post