0

I'm using VLOOKUP to return a value from a second sheet, which is working fine.

=VLOOKUP(B7,Sheet2.A1:Sheet2.B40,2,0)

However, If I try to use the value returned by this formula in another formula, I get the result of #VALUE!.

For example, Sheet1.B8 uses the above formula to get a value from the second sheet. If I then reference Sheet1.B8 in any mathematical formula (=1 * Sheet1.B8), the result is always #VALUE!.

What am I doing wrong, and how can I make this work?

Improve this question
10
  • What formula you are using that references Sheet1.B8 elsewhere?Can you mention that as well.
    – patkim
    Commented Oct 4, 2016 at 13:58
  • @pat2015 I've updated my post. The problem occurs with any mathematical formula.
    – Tester101
    Commented Oct 4, 2016 at 14:03
  • 2
    Is your VLOOKUP returning numeric value or it may be a text value?
    – patkim
    Commented Oct 4, 2016 at 14:07
  • If you are using . as the separator between sheet.cell that is the problem... It's sheet!cell --- I'm not sure why it's working in your vlookup formula.
    – Tyson
    Commented Oct 4, 2016 at 14:08
  • Try formula say =1*VALUE(Sheet1.B8) and see what happens now
    – patkim
    Commented Oct 4, 2016 at 14:17

1 Answer 1

Reset to default
0

Looking closer at the data in Sheet2, I noticed that the "numbers" were not actually being recognized as numbers. When I pasted the data into the sheet, tabs and spaces were included in the cells. This caused the cells to be text, rather than numeric.

Not sure why the blank space was not removed when pasting the data, but removing it solved the problem.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .