v-look up - no results

[Guest]

When doing v-lookup from one spreadsheet to another, it displays the formular
instead of the result. I pulled the first set of numbers out of a database
and made sure they are all numbers, not text. The second set of data was
sent to me and seems also to be numbers.

 

[Ken Wright]

Chances are that your sheet is set to display formulas, OR, the sheet is
formatted as text prior to you putting in your formulas.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[Pete_UK]

Two things to check for:

1. sheet is set for manual calculation - press F9 to recalculate, and
if this corrects it click on Tools | Options | Calculation tab and
click Automatic instead of Manual for a more permanent fix.

2. cell is formatted as text - click on Format | Cells | Number tab to
check for this, and set to General. Click OK, then double-click the
cell as if to edit and then press Enter to make the format change take
effect.

Hope this helps.

Pete

 

[JE McGimpsey]

If the cell displays the formula (only one 'r', unless you're from
Boston), you're entering it in a cell that's been formatted as Text, so
XL doesn't try to interpret it as a formula.

 

[Guest]

Hi guys:

Did all that. Checked for auto calculations, formulars etc. Now I wanted
to start fresh again, I have two separate worksheets, click on the number
which is the same in both so that I get the info from the second worksheet
into my own, but now I can't even say which cell range to look up the number.
As soon as I want to go into the second worksheet to highlight my range, I'm
stuck there.

 

[Peo Sjoblom]

Given the name it sounds as she's from Sweden or maybe some other
Scandinavian country <g>


--


Regards,


Peo Sjoblom