CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
inexcelsheetsdeo
inexcelsheetsdeo

Reputation: 3

Searching a range of cells for each nonzero value and then returning that value AND corresponding data in row/column where data intersects?

I'm trying to figure out how to search the range of values from here and return a few data points.

The output I'm hoping for would look like:

Is there a function that would search down column G, move to column H, and so on?

I've tried vlookup/hlookup but that only returns the first value and I can't figure out how to also pull the data in column F and row 2 as well. Same sort of confusion with index and match functions as well as query which I don't think I totally comprehend. Any help would be so appreciated!

Also the data in that range is already the result of using the filter function on a much more complicated spreadsheet.

Upvotes: 0

Views: 51

Answers (1)

rockinfreakshow
rockinfreakshow

Reputation: 30240

Within sheets you may try:

=tocol(index(if(G3:R6,text(G2:R2,"m/d")&" "&F3:F6&" "&G3:R6,)),1,1)

Adjust the ranges in the formula as per the dataset in your sheet

enter image description here

Upvotes: 0

Related Questions