Solved

Can vblookup be used for comment

Posted on 2014-09-10
6
77 Views
Last Modified: 2014-09-21
Experts,

Is it possible to use vlookup in Excel for a comment field.  I am asking because I have spreadsheet that changes as to what is in columns "C7 through C420".

I was looking for a way to display the description of the respective code.  The descriptions are too lenthy to add another column and stll have the required data on one sheet.
0
Comment
Question by:morinia
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 26

Expert Comment

by:ProfessorJimJam
ID: 40315102
check the example uploaded.
C--Users-jamilm-Downloads-Vlookup-in-Com
0
 

Author Comment

by:morinia
ID: 40315251
I cannot open this file.  Can you make Excel file
0
 

Author Comment

by:morinia
ID: 40319415
I've requested that this question be deleted for the following reason:

The file is a format that I cannot open and I am not sure that it is safe because I cannot see it.
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
LVL 26

Accepted Solution

by:
ProfessorJimJam earned 500 total points
ID: 40319070
Please see attached three versions of Vlookups that involves comments.

the files are macro enabled becuase the vlookups are user defined functions placed in the module of excel
Vlookup-in-Comments-Second-Version.xlsm
Vlookup-in-Comments-Third-Version.xlsm
Vlookup-in-Comments.xlsm
0
 
LVL 26

Expert Comment

by:ProfessorJimJam
ID: 40319071
you can cancel your delete request, becuase i have provided you with three different solutions.
0
 

Author Comment

by:morinia
ID: 40335718
Professorjimjam,

Can you assist me in implementing your code in the attached spreadsheet.  I have a sample of columns with comments. The vlookup in column "F" is what I would like to see in the respective comment in column "A".
vlookup.xlsx
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa‚Ķ

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question