So I'm using the attached spreadsheet as a fantasy soccer project. Under the 1st worksheet tab, various cells using the VLOOKUP function are returning results that reference a cell. For instance, Cell I-8 has a result of "=D51"
How do i get it to display the actual result?
G'day and welcome to the forum,
What you need to do is go the cell which displays those references and change the format to general.
Click on the cell D51 change the format from text to general then click in the formula bar then press enter.
Then to the following for the other cells
HTH
Last edited by ratcat; 10-03-2008 at 07:21 PM. Reason: typo
Have I made you happy ??? If yes, please make me happy by pressing theAdd Reputation button in my post.
Please don't forget to do the same to other contributors of this forum.
ThanksI don't void confusion, I create it
The format of the cells is already set to general, and is still displaying results such as =D51 instead of the correct text it should display.
Also, the formula requires that commas be used, which I double checked, and they have been used properly.
Any other ideas?
Hi,
What should be displayed?
The vlookup formula is displaying what you have asked for!
Regards Howard
Last edited by Gearcutter; 10-07-2008 at 03:31 PM.
It should be displaying the contents of D51, not =D51.
G'day PLtech,
Please do the following at these cells
D55, D56, D75, D76, D77, D78, D96, D97, D98,
Click on the cell change the format from text to general then click in the formula bar then press enter.
Please do this individually.
This should fix all your problems across the spreadsheet.
That comment your referring was not directed too you. It is part of my signature.Originally Posted by PLtech
If that does not help, I will upload my alteration on your file.
Cheers
G'day PLtech,
Here's your request
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks