Solved

Can I use Vlookup here

Posted on 2013-10-27
4
254 Views
Last Modified: 2013-10-28
Hi,

Can I use Vlookup to update the category and sort columns with the data section with the category and sort section of the category table.  Here is example of the what I am talking about. See the attached spreadsheet.  I am also open to any suggestions

Thanks in advance
Vlookup.xlsx
0
Comment
Question by:Kdankwah
[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
  • 2
  • 2
4 Comments
 
LVL 9

Expert Comment

by:jsdray
ID: 39604745
not sure I'm following your request.... could you explain a bit more?
0
 
LVL 9

Expert Comment

by:jsdray
ID: 39604754
vlookup is used to extract information from a table based on a known value.
taking the known value, it looks up a match (or closest match) in the table and returns the value of the desired column of that table.
0
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 total points
ID: 39604786
Enter this formula in C3 and copy down

=VLOOKUP($A3,$A$13:$E$21,3,0)

and this formula in D3 and copy down

=VLOOKUP($A3,$A$13:$E$21,4,0)
0
 
LVL 43

Assisted Solution

by:Saqib Husain, Syed
Saqib Husain, Syed earned 500 total points
ID: 39604788
This single formula will also work in this particular case. Enter it in C3 and copy it down and across

=VLOOKUP($A3,$A$13:$E$21,COLUMN(),0)
0

Featured Post

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

Question has a verified solution.

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

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
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 Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

733 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