Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 265
  • Last Modified:

Can I use Vlookup here

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
Kdankwah
Asked:
Kdankwah
  • 2
  • 2
2 Solutions
 
jsdrayCommented:
not sure I'm following your request.... could you explain a bit more?
0
 
jsdrayCommented:
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
 
Saqib Husain, SyedEngineerCommented:
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
 
Saqib Husain, SyedEngineerCommented:
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now