VLOOKUP: lookup_value not working if referring to a cell containing a formula

Hi all

I am using this formula to lookup a value in another sheet:

=VLOOKUP(A1;SheetB!$A$1:$E$60;5;FALSE)

The value which I want to look for is in cell A1. Cell A1 contains a formula.

My problem: If I use the formula above I get a N/A. If I place the value (a number) into the formula where A1 stands I get the result as I want.

I checked the cell format - and both are the same (i.e. numbers).

Thanks in advance for your help.

I have had problems with numbers as keys so I convert both key and lookup values to strings

What is the formula in A1, it sounds like your formula is returning a number stored as text, regardless of the cell format. Have you tried:
=VLOOKUP(1*A1;SheetB!$A$1:$E$60;5;FALSE)

try this in any cell =EXACT(A1,yourvalue) if this return FALSE, then your formula in A1 returns different value

alternatively try this =VLOOKUP(round(A1;0);SheetB!$A$1:$E$60;5;FALSE)

Thank you yudlugar!

It returned a number as text. Now it works!