Solved

Can vblookup be used for comment

Posted on 2014-09-10
6
73 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
  • 3
  • 3
6 Comments
 
LVL 25

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
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

 
LVL 25

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 25

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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

776 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