• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dashboard with VLookup

thejinxed

thejinxed

New Member
Hi,

Any help is much appreciated. I have tried unsuccessfully to do the following with VLOOKUP:

My dashboard includes a blank cell (R8) that I would like the user to be able to input ANY case number and have it return the survey comment sent by the customer.
I have the blank cell R8 for user input. IE: 316390, 328727, etc
I have also merged cells R10:V17 so that the comment might fit (this is where I am placing my formula =VLOOKUP(R8, Comments!A2:A1071,Comments!8,True)
I have tried INDEX and MATCH as well. I'm stumped.
If a file is still needed, I can try to get this in a smaller format; it's too large to upload at this time, unless a zip is okay)
 
Hi,

Your VLOOKUP formula second argument is a single column where it should be a table. Also, 3rd argument should be column number where as it is row number 8. plus if your case number are not sorted than 4th argument TRUE will not work.

Try these changes and write back. If possible please upload a small sample file with say some 10 cases.

Regards,
 
What columns are the comments in on the Comments sheet?
If I guess they're in column H (column 8) then perhaps:
=VLOOKUP(R8, Comments!A2:H1071,8,FALSE)
(which also assumes the case numbers are in column A)
 
=VLOOKUP(Dashboard!R8,Comments!A1:G2000,7,FALSE)
The range for the lookup is currently A1:G2000, adjust this to suit if it's not large enough.
See attached.
 

Attachments

dieselkhan said:
or use

=+VLOOKUP(R8,Comments!$A:$H,7,0)
Click to expand...
Are you able to enter a case number and pull the comment and then enter another case number and retrieve another comment? That is my problem. The first one will work, but after that it does not work unless I access the formula and at the end of it hit enter. Then it loads the new comment for the new case number.
 
thejinxed said:
Are you able to enter a case number and pull the comment and then enter another case number and retrieve another comment? Thank is my problem. The first one will work, but after that it does not work unless I access the formula and at the end of it hit enter. Then it loads the new comment for the new case number.
Click to expand...

Hi,

I think your worksheet calculation mode is set to manual, try looking at it.

Regards,
 
Somendra Misra said:
Hi,

I think your worksheet calculation mode is set to manual, try looking at it.

Regards,
Click to expand...
You are a genius! I had my formula correct the whole time! The calculation mode was the problem. For as long as I've been using Excel, I did not know this existed.

It just goes to show, you can teach an old dog new tricks! :)
 
You must log in or register to reply here.
Back
Top