• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1129
  • Last Modified:

VLOOKUP not calculating

VLOOKUP is not calculating. It shows the formula in the cell instead of the result. The same formula is working fine in a different workbook referencing the same data array.

Any help would be appreciated.
Tom



=vlookup(A2,'[Opportunity History.xls]Opportunity History'!$A$2:$B$40425,2,false)

Open in new window

0
hrtmath
Asked:
hrtmath
1 Solution
 
jpaulinoCommented:
Do you have the cell defined as text ?
0
 
Saurabh Singh TeotiaCommented:
Two things that you need to check.
1. Check the format of the cell..that is right click over it-->format cell and if its formated as text format the same as general.
2. Go to-->tools-->options-->view-->and if the formulas are ticked under windows options uncheck it and hit ok.
Its because either of above two reasons its displaying formula not result...
Saurabh...
0
 
Rory ArchibaldCommented:
Note also that after formatting the cell as General, you will need to select the cell and press f2 then Enter to re-enter the formula. Or, if you have a lot of formulas to do, select all your cells and then use Edit -Replace and replace = with = to force a recalculation.
Regards,
Rory
0
 
patrickabCommented:
Press and hold down CTRL and then press the key next to the 1 above the TAB key (it's the
¬ key) - release the CTRL key.  That key combination (CTRL+
¬) toggles between showing the formulae and the results.
Patrick
0
 
patrickabCommented:
Previous comment formatted badly - so here it is again, hopefully better formatted...

Press and hold down CTRL and then press the key next to the 1 above the TAB key (it's the
¬ key), release the CTRL key.  That key combination (CTRL+¬) toggles between showing the formulae and the results.

Patrick
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now