multiple columns and rows

Hi, I have two columns with values and want to check both cells in a row (A2 and B2) and depending on the value found return the quantity from sheet 2 column 2 Both corresponding cells (A2 and B2) will not have data but there will be data in either of them. Row Column A Column B 2...

I'm trying to write a formula that will count the number of rows that contain "Yes" or "No" in multiple columns. However, if more than one column for the same row contains "Yes" or "No" I only want the row to be counted once. Here's what I've tried: =SUM(ISNUMBER(MATCH(Data!$AQ$3:$AQ$1000...

I have been searching for a code that does what I am hopeful is understandable to whomever may be able to help me with this. I have multiple columns with multiple names (10 columns in this case), some names are duplicated, and need to generate all possible combinations of these 10 columns of...

Can someone help me adjust this formula to return the Nth "group" that a "name" is in? And if the "name" only occurs once, the search for the 2nd occurrence will return ""? Sticking with the pictured example, I would like each person's 1st group to show in column H [like it already is] and each...

I've copied snippets of my data from two tabs: "Pokémon" & "Fast TMs". As an example, we'll use Nidoking, who's pokédex number is 34. I need cell I16 in the first table to find Nidoking's # ("34") in the second table (cell M6) and return the name of his Move ("Iron Tail"). I'll then need a...

Thank you in advance. I have a spreadsheet with participants winning multiple awards. I want the awards in separate columns tiled Awards 1 Award 2 Award 3.... I have this... <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> Name Award Jane Gold...

<tbody> </tbody> first row is building name, next row is dept #, next row is area of study. The dates to the right are all of the dates that a meeting is scheduled. I am trying to search a specific date and return a result that lists the bldgs, dept, area for that specific date. Below...

I am attempting to sum a range (multiple rows and columns) based on multiple criteria (location, type, and if it contains value >=0) in another tab in workbook. I have attempted sumifs, sum(if()), and array formulas but have been unsuccessful. =SUMIFS('TRUCK Utilization'!P$7:P$367,'TRUCK...