Questions tagged [vlookup]

For questions about the VLOOKUP spreadsheet function that allows the mapping of a selection (a ‘search key’) to a result in the same row of a table (‘range’ or ‘array’).

Filter by
Sorted by
Tagged with
4
votes
1answer
7k views

Multiple conditions look up

I am having trouble building a spreadsheet, the problem its my data table. I want to be able to pull data from the table, something that will match data from column A, and column B (on the same row) ...
1
vote
1answer
24 views

Subclauses in formulas?

Quite often I end up including the same calculation in a formula twice, like this: =if(iserror(vlookup("lookup",SheetX!A2:X350,5,false)),"",vlookup("lookup",SheetX!A2:X350,5,false)) I'd like to ...
4
votes
2answers
231 views

Pick the first value in every row that has not been picked yet

In the example I am giving below, I would like the result in Column G to be what is in Column C, unless it already exists in Column G in rows above it: These rows represent students' choices for ...
3
votes
1answer
466 views

Partial match for strings that are truncated beyond 30 characters

I have two sheets. Sheet one has a list of events in column N: "IEM Katowice", and others. However, our system imports event names that are longer than 30 letters (including spaces) with a .. at the ...
5
votes
1answer
18k views

VLOOKUP issues not finding a value that's in its range

Here's a link to a copy of my spreadsheet. I am attempting to do the same formula using a VLOOKUP in four sheets to do a calculation called LSI. In the first sheet I have the raw data from a form ...
2
votes
1answer
906 views

How to perform a VLOOKUP with search column dynamic depending on input in another cell

I have the following table: What I want to do is as follows: User selects either Minor, Medium or Major to specify which column is used. User then inputs a number 1-100 and the chart then looks to ...
2
votes
1answer
1k views

Use an array/list as VLOOKUP search key

I have two sets of data. The first is an ever growing list of names, which we'll call Names (not necessarily a named range). Something like: John Bill Bob Steve The second is also a growing set of ...
0
votes
1answer
1k views

Using VLOOKUP with dynamic range array

I have a sheet with a list of email addresses that is being auto-updated (more email addresses being added on a daily basis). I have a second sheet with a list of email addresses that have been ...
1
vote
1answer
71 views

Summarize the best options in another table

I need help to create a sheet for a game. I am providing the INPUT, and I would like to create the OUTPUT in another tab (do not consider the colors, its just for ease of understanding): Mainly, the ...
1
vote
1answer
5k views

How to return array of cells from a table in Google Sheets

We have # EXAMPLE TABLE with product SKUS on the top row, and the first columns is ingredients. Each SKU row is showing the value of the ingredient row. What we want to do is have another sheet with a ...
-1
votes
1answer
700 views

In Google Sheets, I'm trying to create a drop down that reads from 2 columns but returns from 1 column [duplicate]

Basically, I have store number and Store name. I want to be able to start typing a name and select the name, but only show the store number. If that is not possible, then I thought I can combine ...
1
vote
1answer
1k views

Google Sheets - Sum of vlookup in one cell

Hitting a brainfreeze, can't figure it out. Problem: I can't figure out how to add together Table#1 Sam WC results as a nice table for Table#2. What I need is the results in Table#2. Table #1: | ...
-1
votes
1answer
517 views

Vlookup in external spreadsheet

Is it possible to use VLOOKUP with an external spreadsheet? SpreadsheetA contains a set of a few hundred addresses. SpreadsheetB is an invoice. I want to use VLOOKUP in the invoice to return ...
1
vote
2answers
2k views

Arrayformula for entire column in Google Sheets with a lookup not working

I have been working on automating a reporting sheet I have and discovered the very handy use of arrayformula in Sheets that autofills the column with your formula based on data in another column. ...
1
vote
1answer
5k views

Validate dropdown from 2 columns

Sheet 1 has column A called CONTRACTOR Sheet 2 contains CONTRACTOR details. Column A has Company Name, Column B has Contact Name If I start type a name in column A on Sheet 1, how would I get ...
1
vote
1answer
1k views

VLOOKUP problem with value from =arrayformula(iferror(regexextract

I'm trying to use VLOOKUP to pull data from one tab in a Google Sheets workbook into another tab. The VLOOKUP formula works if the value being searched for is 100103, but not the cell reference G2 (...

1 2 3
4