LOOKUP function not working..but if i use ' so it works..?

[Masino]

Hi guys,
As i wrote in the title, i have a list of numeric codes that i copy paste from a file to another. It has supposed to lookup for those values in another sheet and the return the result.
Everything fine.
It has work for long time..but now no more.
I discovered that, if i put the symbol ' before those numbers and the press Enter, so the i got the "green triangle" on those cells, and it works!
I tried to convert format and all those stuff but with no results.
Now my problem is that every day i have to select, put ' at the end of the codes and press enter..for about 1500 lines, daily.
Has anyone any solution to this?
Thanks a lot and do not hesitate to ask for more info.

 

[bebo021999]

May be actual number in cell, and then "searching value" in LOOKUP is "number_stored_as text" then it does not work, untill cell value is converted to become text.
Give in a try: use "searching value"+0
=LOOKUP(A1+0,...)
With cell A1 contains "value_stored_ as text"
If it does not help, try to paste the whole LOOKUP formular here, and a screenshot of invoving range.

 

[Masino]

Thank for your reply.
Unfortunatelly it tried without success.
My formula is :
=LOOKUP(B7;'Varer Visma'!E:I;5;0)

I also tried to change format ( text, standard, number), but no result....

Here is a picture of it :

Sk-rmbillede-2022-09-01-071036

Image Sk-rmbillede-2022-09-01-071036 hosted in ImgBB

ibb.co

Thank you again

 

[bebo021999]

Not yet open the attchment, but below formula structure seems wrong:
=LOOKUP(B7;'Varer Visma'!E:I;5;0)
Do you mean VLOOKUP, not LOOKUP:
=VLOOKUP(B7;'Varer Visma'!E:I;5;0)

???

 

[Masino]

No no, i mean Lookup
Btw, i solved the problem.

I created a vba macro to set ' leading all the cells i need, in my case from B7:B999.

Formula is:

Sub MasinoMacro()
for each v in range("C6:C11") : v.value = "'" & v.value : next
End Sub

 

[Masino]

No no, i mean Lookup
Btw, i solved the problem.

I created a vba macro to set ' leading all the cells i need, in my case from B7:B999.

Formula is:

Sub MasinoMacro()
for each v in range("C6:C11") : v.value = "'" & v.value : next
End Sub

Sub MasinoMacro()
for each v in range("B7:B999") : v.value = "'" & v.value : next
End Sub