Excel 2007 : Multiply a Vlookup return

[stevetothink]

I'm trying to multiply the results of a vlookup by a another cell but it returns #VALUE.

=(VLOOKUP($O549,DB!$P$3:$Q$44,2,TRUE)) * A1

Any ideas what I'm doing wrong?

Thanks,
Steve

[NBVC]

What does the result of the VLOOKUP only give.

i.e. =VLOOKUP($O549,DB!$P$3:$Q$44,2,TRUE)

What is in A1?

[stevetothink]

What does the result of the VLOOKUP only give.

i.e. =VLOOKUP($O549,DB!$P$3:$Q$44,2,TRUE)

What is in A1?

Nevermind - I just realized my vlookup is returning a number stored as text. That's the problem.

[NBVC]

Multiplying a number stored as text by another number (stored as text or not) should still yield the result... unless there really is text in the cell(s)