VLookup Problem with Fomulated Lookup Value

[Eb0la11]

I have this as my VLookup formula:

=VLOOKUP($B24,'Reference Tables'!$A$2:$B$100,2,FALSE)

B24 ends up pulling the formula result of "4" as this cell is a formula itself which is this:

=IFS(LEN('Q-Tools Data'!$A2)=12,LEFT('Q-Tools Data'!$A2,1),LEN('Q-Tools Data'!$A2)=13,LEFT('Q-Tools Data'!$A2,2),LEN('Q-Tools Data'!$A2)=14,LEFT('Q-Tools Data'!$A2,3))

its like it can't see that B24 is just 4. Instead it gives me an error, but if I type in 4 into the cell and replace that formula it works fine.

Can I not use Vlookup to look at a formulated cell or do I have to add an additional piece of information or formatting?

 

[Fluff]

The LEFT function returns a text value, try
=--IFS(LEN('Q-Tools Data'!$A2)=12,LEFT('Q-Tools Data'!$A2,1),LEN('Q-Tools Data'!$A2)=13,LEFT('Q-Tools Data'!$A2,2),LEN('Q-Tools Data'!$A2)=14,LEFT('Q-Tools Data'!$A2,3))

which should convert it into a number

 

[Eb0la11]

Ha! Same solution as my last question. Thanks again good sir.

 

[Fluff]

You're welcome & thanks for the feedback