# 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

**0**answers

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

**0**answers

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

**0**answers

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

**0**answers

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

**2**answers

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

**0**answers

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

**1**answer

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

**0**answers

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

**0**answers

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

**1**answer

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

**3**answers

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

**1**answer

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

**2**answers

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

**2**answers

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

**1**answer

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 ...