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
0 votes
1 answer
57 views

How to fix VLOOKUP when it returns the incorrect value from the bottom of the list?

In Google Sheets, I am having trouble with a VLOOKUP function. range argument A2:B contains text strings. search_key is in column C, example, C2 index argument is (column) 2, which is equivalent to ...
Ylahris's user avatar
  • 181
2 votes
1 answer
58 views

Looking up two criteria in a table, one vertical, one horizontal and finding a value

I have a large table of data. Column A is names Columns C-I are monthly commissions. (Column C is March 2023, Column D is April 2023, etc) Columns C-I are going to change regularly as we are pulling ...
Lisa Masquelier's user avatar
1 vote
0 answers
33 views

Google Sheets - pull multiple lines of data from Workbook1 based on A1 in Workbook2 [closed]

Ok. So I've been all over this looking for an answer to my problem. I found so much helpful info, but none of it quite solves my problem. So I am here to ask the experts myself. I work for a ...
user312381's user avatar
1 vote
1 answer
535 views

How do I build a formula to select a Category based on different select keywords/phrases in a determined column?

I'm hoping to build a formula to automatially select a category based on select keywords/phrases from an imported bank statement. I attached an editable copy of the Google Sheet I'm looking for help ...
Ryan Voigt's user avatar
0 votes
2 answers
48 views

Google Sheets Formula Help needed - Vlookup/Index/Match

this is my first time on here, I'm hoping someone can help me :) I have a formula that finds the final occurrence of a value in a range and gives me the date for that occurrence =ArrayFormula(LOOKUP(2,...
Chris Dreher's user avatar
0 votes
2 answers
145 views

What's wrong with my formula?

In Google Sheets: First, I'd like to return the values in the whole column of D into Column H if: E and F equal A and B C is not blank This was the formula I tried: =IF(ISBLANK(C2=TRUE),"",...
Dustin's user avatar
  • 15
1 vote
1 answer
202 views

How to look up if an employee is on time [closed]

I have the raw attendance of my team in one tab, and I created an IF statement to identify whether they are tardy or on time-based on their scheduled time (8 am PST). N2 = actual log in O2 = ...
Emma's user avatar
  • 11
0 votes
1 answer
91 views

Google Sheets - Sum Filter of Table 1 in each row of Table 2

I have table of transactions with categories (let's say 1-5) and assigned dollar values, and another table with a list of each category. I want to sum up all the matching categories from Table 1 with ...
jpfieber's user avatar
1 vote
1 answer
45 views

Return value with VLOOKUP that has three search criteria - two values and one blank cell

Based on the Columns A AND B, (which are duplicates), I'd like to return the value in Column D IF Column C is blank
Dustin's user avatar
  • 15
-1 votes
2 answers
124 views

How to structure a vlookup in an arrayformula to accept multiple columns?

I have been working on this problem for a week, where I was looking for the totals of specific row items in a range multiplied by a factor. The formula below achieves the desired outcome. I need help ...
Glenn Morris's user avatar
0 votes
1 answer
64 views

If cell A1 contains 'john' then cell B1 should equal 'red', if cell A2 contains 'paul' then cell V2 should equal 'blue'

Let's say we have a table like below which pairs each name with a colour: Name Colour Paul blue John red I would like a formula in the 2nd column below that will say: if cell contains 'Paul' then ...
fini-stair's user avatar
1 vote
2 answers
88 views

Google Sheets Function or Script: like VLOOKUP but Search in Multiple Columns (NOT Multiple Criteria)

I thought this would be simple but having a hard time searching because when I look up something like "find value in range with multiple columns" all I get back is how to search for multiple ...
cu5ya7's user avatar
  • 13
1 vote
1 answer
85 views

How to return table value?

I need to do the following: If cell is "Situation X" then show in cell next to it value from interval and specific situation. For example: If cell A1 is "Situation 6" and value ...
Rip's user avatar
  • 11
2 votes
2 answers
64 views

Retrieving the most recent game record in google sheets

I have a google sheet that looks like this: Player 1 name Player 2 Name Player 3 Name Player 4 name Player 1 Pre-Game ELO Player 2 Pre-Game ELO Player 3 Pre-Game ELO Player 4 Pre-Game ELO Player 1 ...
Daniel Paczuski Bak's user avatar
0 votes
1 answer
537 views

VLOOKUP between two dates in Google Sheets

I'm having trouble with a vlookup between two dates. This the case: In my first tab I have the following data: You can see that person "Stephen Chesson" has another profile from 01/08/2022. ...
nielsv's user avatar
  • 139
1 vote
0 answers
16 views

VLOOKUPS with a date condition

So I have a table with clients' names. As my team expands, some clients are shifted from one team member to another one. My table looks like this Starting date End date Client name Team member name ...
Lise's user avatar
  • 11
0 votes
0 answers
33 views

IF and Arrayformula for Google Sheets

=IF(C2=""(vlookup('FBA Returns'!B:J,9,0),vlookup(C2:C'RMA Main Sheet'!D2:H,5,0))) IF "C" is blank, Vlookup "B" on Sheet 1, IF "C" is NOT Blank Vlookup Sheet 2. ...
Joseph Lim's user avatar
0 votes
1 answer
34 views

How to find an invoice number in a sheet than an item in the list of the items of the invoice to get the sold numbers of the item [closed]

I have a list of invoice numbers in a column. In another sheet I have the same invoice numbers but with items in another column and a third with sold numbers. I'd like to get this sales data in the ...
Kőhegyi Atilla's user avatar
-1 votes
1 answer
39 views

Return the value in same row if specific text exists with a range of cells

I am looking for a way to scan a range of cells for specific text, and if that text exists within that range, display the corresponding value in the same row within another range of cells I have ...
Clay's user avatar
  • 1
0 votes
1 answer
712 views

Search across multiple columns for a value(s) return multiple row results

I am a rookie at this and I spent hours trying to figure this out but can find anything that really helps. Scenario 1: Looking at the photo. I want to search columns C through M for a selected color(s)...
william holman's user avatar
1 vote
0 answers
23 views

Lookup In Multiple Sheets & Add Unique Identifier

I'm trying to create an email lookup worksheet that essentially lists the results of a search throughout multiple worksheets (all in the same Sheet document). As an example, I have "Sheet 1",...
Dave's user avatar
  • 11
0 votes
0 answers
24 views

VLookup multiple items into one cell

In Google Sheets, I have a Vlookup working for a column with the thing I'm looking for, then two columns in a different sheet with sheetname! where it looks for the thing I'm looking for and gives me ...
sheetfun11's user avatar
0 votes
1 answer
37 views

How do I put the if function inside the lookup? - Daily Routine sheet

I have a sheet - daily routine which has two columns: activity and time as shown here Activity Time Sleep 😴 6:00 am Toilet 🚽 6:15 am Get ready for gym 🤸‍♂️ 6:30 am Exercise 💪 7:50 am ... ...
Arun's user avatar
  • 101
1 vote
1 answer
265 views

Extending a formula (VLOOKUP) to the whole column

I created a VLOOKUP formula inside a Google Sheet, I have 130000 lines and need to extend the formula to the end of the column.
Nesaia's user avatar
  • 11
0 votes
0 answers
32 views

Multivariable Matching in Google Sheets - scanning for multiple values simultaneously and posting shared data

I have two sheets from two different sources (Facebook Ads and Google Ads) and I want to match their data onto a third sheet. The data itself is different, but the identifiers are the same - campaign ...
user avatar
-1 votes
1 answer
60 views

Fantasy Football league stat tracker

I am the commissioner of a small tabletop football league in Southern California. I'm currently using a league template spreadsheet to track individual player stats (TDs, passes, etc.), match results, ...
Ry Finerty's user avatar
0 votes
0 answers
303 views

Google Sheets - VLookup and date

My problem is that I am unable to return a value based on a specific date (eg "01/28/2022") within a Google Sheet using VLookup. I have searched the site and cant find a solution. I have 2 ...
G GM's user avatar
  • 1
0 votes
2 answers
57 views

Using the contents of a cell to act as a range in VLOOKUP

I AM USING GOOGLE SHEETS, NOT SURE IF THIS IS THE BEST PLACE TO POST BUT FOR CLARIFICATION! Hi there, I am attempting to index the contents of a cell and use that as the range in my VLOOKUP formula. ...
Sam's user avatar
  • 1
0 votes
1 answer
26 views

Reorganize csv data

I work in a school that has multiple data entry forms and formats and I am trying to find a way to automate one example of data duplication. We put student report card grades in on one online system, ...
Philip Angell's user avatar
0 votes
1 answer
443 views

In Google Sheets, can you repeatedly autofill until next non-blank cell or until a value in another column changes, whichever comes sooner?

I'm trying to format a CSV file that contains a huge list of products (8000+) that are on separate rows but need all the fields to be on the same row. The trouble is that some of the cells are ...
Christian Guest's user avatar
0 votes
2 answers
451 views

VLOOKUP or MATCH with IF GREATER THAN

Is it possible to automatically pull a list of students with 2 or more absences onto another tab in Google Sheets? In the following link, the first tab has a list of students and how many absences ...
Sarah Savoy's user avatar
0 votes
2 answers
692 views

Vlookup when multiple values in one cell

I want to find a short solution to find the matching Korean term of column A in "English" from sheet "Korean." For now I have split column A and then used Vlookup for each value, ...
Luoni's user avatar
  • 9
0 votes
1 answer
195 views

Offset a Vlookup across multiple sheets

I recently received help on creating a formula to fill in data on a Google sheet for customer orders, this goes between sheet1 (master) and sheet2 (selected data only, depending on the reference cell)....
Kimmie's user avatar
  • 15
0 votes
0 answers
84 views

Array Formula Problem - How to Fill In Blank Rows with the Same Value before a Breakpoint which advances to the next letter

I have a Google Sheet which is grouped into segments of a TV show. So there's an A segment and then a B segment and so on ... I have allocated two columns to provide two different timing functions (...
Gary K's user avatar
  • 5
1 vote
2 answers
125 views

How to SUM the VLOOKUP results based on condition in other column using ARRAYFORMULA?

I would like to sum all the costs based on the products purchased between specific dates. =SUM(ARRAYFORMULA(IFERROR(VLOOKUP('Purchased List Table'!B2:B,'Pricing Table'!A2:B,2,0),""))) With ...
Ryan's user avatar
  • 13
0 votes
1 answer
985 views

vlookup with multiple output and combining filter() with arrayformula()

I have 2 sheets : shot and deadline. https://docs.google.com/spreadsheets/d/1drNUQVtAxd0HU4QCVSKJSsKHoanE735n8HsjkYpYiGs/edit?usp=sharing This is my shot sheet : and this is the deadline sheet : So ...
andio's user avatar
  • 315
0 votes
1 answer
103 views

Need Script changed to a different page in the same sheet

I have a script on a sheet in my Google Sheets workbook that emails when a cell changes to "TRUE", but the cells in question are a vlookup to another sheet in the workbook. This works in the ...
Joseph Yearous's user avatar
2 votes
1 answer
3k views

Using Vlookup with Dates

Here's the set up to the problem I'm having. I have a column of dates and a column of truck numbers. I'm trying to use VLOOKUP to find what truck numbers correspond to the dates. There are multiple ...
Ronnie Walker's user avatar
0 votes
1 answer
142 views

Google Sheets VLookup Help

So, I am trying to use the VLookup function to find the value of a cell that corresponds with todays date and return that cell information. However, if there is no date given for todays date, then I ...
TheTechZombie's user avatar
0 votes
1 answer
513 views

Using VLOOKUP with pivot table - OR - another way to aggregate data

My sample is here: https://docs.google.com/spreadsheets/d/1j9pRECnAKtKtvAfhMvLv93-u6_kwIrFZg3RY3jSkpkU/edit?usp=sharing I am trying to aggregate the last date that each "familyID" was ...
Leo's user avatar
  • 3
1 vote
1 answer
298 views

Google Sheets: VLOOKUP formula for a multi line cells range

I have here a sample project, where columns A to C are in FORM RESPONSES TAB/SHEET and columns D and E are in RECORDS TAB/SHEET. In the RECORDS I have a list of names, in alphabetical order, and a ...
ToyDarts's user avatar
0 votes
1 answer
146 views

Find given time and date in named range

I have a Google Sheet with my wife where we both enter our upcoming events. They are included in named ranges and passed to the main sheet where the information is displayed. For example, I enter in ...
AClay47's user avatar
1 vote
0 answers
47 views

How can I use a dropdown menu in Google Sheets filter out data and populate cells for a an expense tracker?

I have created a personal expense tracker (budget) that uses google form responses and categorizes them by fortnights and expenditure categories. This has been successful on a sheet called 'Yearly ...
Sarah Harris's user avatar
0 votes
1 answer
49 views

Look up rate for specific person in effect on or after a date

In this Google Sheet, I have one sheet, "Transactions", with a rate entry that should be auto populated from a table in the "Rates" sheet. The formula should look up the rate for ...
libbynotzoey's user avatar
2 votes
1 answer
77 views

Searching cells and pulling values in Google Sheets?

sorry for the vague title but I'm not sure how exactly to describe this. I've created a spreadsheet and used the Coinmarketcap API to pull lots of data, here's the relevant part: From another sheet I ...
Nick's user avatar
  • 381
0 votes
1 answer
29 views

Why does VLOOKUP find a match in a sequence of dates when there is none?

I am working on spreadsheet that works with a school calendar. I have a sequence of dates that is a list of Wednesdays. I am trying to do a VLOOKUP on it to find out what type of day a specific date ...
Phil Anderson's user avatar
0 votes
1 answer
240 views

Copy data based on date to another cell but other column date is not exact match

I want to match the dates in Column A to the Closest date in Column E (if a date in column A doesn't match to dates in Column E then I want to return the next available date in Column E and I've done ...
Jumanji ji's user avatar
2 votes
2 answers
2k views

Categorize text in Google Sheets based on matching partial text in the Category index

I'm looking to match, with VLOOKUP, part of the words in a column in the main sheet to an index of keywords/categories where partial words are stored for ease in another sheet. Here's an example ...
PKHunter's user avatar
  • 151
1 vote
1 answer
318 views

Search multiple columns for one value

This is roughly what my table looks like: A B C D E F Name |Ingredient 1 |Ingredient 2 |Ingredient 3 |Ingredient 4 |...
Genny's user avatar
  • 345
0 votes
1 answer
228 views

How to assign country based off list of either provinces or states?

I have a list of names and locations. Most of the locations include the name of the province or state. Some only include country names, some include state abbreviations. I also have a list of ...
Miranda's user avatar