Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [vlookup]

VLookup is a Microsoft Excel function that searches for a value in the left-most column of a table array (a range), and returns a value in the same row based on the column number from which the user wishes to retrieve the value.

0
votes
0answers
19 views

How to create a formula that sums several items in the same cell, but values are set with VLOOKUP function?

I need to list several alphanumeric codes in the same cell and have them do 2 things: Reference a table (using vlookup?) to give each code a specific numeric value. Add all of those values (from the ...
0
votes
0answers
14 views

Return multiple columns with Excel VLOOKUP on Mac

Want to return multiple columns as shown here and here from a VLookup but on Mac. Those examples has the user enter Ctl+Shift+Enter on a PC. I'm using Microsoft Excel for Mac Version 15.41 (171205). ...
0
votes
0answers
25 views

How can i vlookup more than one value

In vlookup formula you define "Lookup value in a specific cell" like A1 or C3 etc. I need to define more than one value like Lookup A2 in E:E Lookup B2 in F:F Writedown Column index: G:G How can i do ...
0
votes
0answers
42 views

Using VLOOKUP to get info from another worksheet

I am using the VLOOKUP function for Microsoft Excel. I am looking at this tutorial here. I want to join my table with some columns from another worksheet. I am struggling with the second argument ...
0
votes
2answers
19 views

Excel Lookups Multiple Columns Concatenated

I have a spreadsheet like this: | hostname | key | value | | host1 | tagA | abc | | host1 | tagB | bcd | | host1 | tagC | efg | | host2 | tagB | hij | | host3 | tagB | jkl | ...
0
votes
0answers
40 views

Vlookup doesn't work at all [migrated]

I am planning a birthday party now, and people have some options when it comes to what to eat. I have a sheet with the options called ¨FOOD¨, then I have an overview sheet where I would like too what ...
2
votes
1answer
23 views

How to use proportions with lookup tables in Excel?

The Min_Prop_of_As shows the minimum proportion of undergraduate students receiving a percentage grade of >=80. I only want to use the undergrad grades in cells C2:C15. How do I write a VLOOKUP ...
0
votes
0answers
33 views

Vlookup query to autofill based on data in other cells/sheets

I've prepared a table in which I need to have a vlookup function to manage multiple criteria based on data in corresponding cells & sheets. I need help to implement the following rules: SHEET 1: ...
0
votes
0answers
38 views

Vlookup query with IF, AND and possibly any other commands

I've prepared a table in which I need to have a vlookup function to manage multiple criteria based on data in corresponding cells & sheets. I need help to implement the following rules: SHEET ...
0
votes
1answer
16 views

Can't use multiple VLOOKUPs in one formula

I am trying to lookup a value from each of my excel sheets, and then add them. It's for a school assignment, so I'm only allowed to use the following formulas: VLOOKUP; HLOOKUP; IF; SUM;SUMIF; AVERAGE;...
0
votes
3answers
65 views

Index and match on multiple columns

I have the following dataset I am trying to re-sort to do a mailing merge with word. I need to suppress the empty cells and match the usernames in an array to the company name they belong to. im ...
0
votes
1answer
70 views

Vlookup /w text replacement

I have an issue I can't figure out. I need to see if two numbers match and the replace with a following cell. So here is the example: If Col G matches Col L Replace D /w Col M. I am using =VLOOKUP(...
0
votes
2answers
50 views

return value if it contains text

I am trying to write a formula to retrieve items from a column only if it contains a set of text inside it. I have been messing with a formula and it returns incorrectly and instead of skipping a line ...
2
votes
2answers
58 views

Using VLOOKUP for multiple lookup values, then summing the outputs

Example: I have a sheet listing the number of calories for various foods. In another sheet I have a list of some of those foods to be used in a meal, and would like to calculate the total number of ...
1
vote
1answer
25 views

Find out index of values within a certain range in Excel

I have a table of values in Excel (2103 if that makes a difference), which when plotted looks something like that: I am trying to find for each series the index of the value, after which point all ...

15 30 50 per page