I have a problem with Vlookup with my practice file

Russel Miller 0
Viewed 29

I have this problem with Vlookup which is already getting on my nerve, I cannot find any generic problems that are the same as mine. Anyways, Vlookup seems not to give out any value or even errors, it just sits there like a text; like this - VLOOKUP(F2,'Reference Table'!$E$1:$H$37,2,0)

Even if I drag this formula down it just copies the formula as a text.

excel-formula vlookup excel
1 Answers

I have literally no clue what you are talking about: I have "copy-pasted" your formula, added a = character in front of it, and this is what I get:

enter image description here

For your information, the Reference Table sheet looks as follows:

enter image description here

Can you edit your question and add some screenshots?

Dominique0
Related