Extracting data from cells in same row as a specific value.

[BrightEyes16]

Hi all.

I'm really stumped with this.

https://docs.google.com/spreadsheets...it?usp=sharing


Basically, I have column A with Box Names and column B with numbers. On another sheet, I need to pull out the Box Names with 13 as their number. It needs to be a condensed list, so the first however many cells in the other sheet should be the names of the Boxes with 13 as their numbers, and the list should update whenever a Box loses or gains a number that makes it something other than 13.


Thanks, I think this one is pretty tough :/

[Ochimus]

Attached does what you want.

Sheet1 lists Box Names in Col A and Box Numbers in Col B

Sheet 2 then has an Array formula that extracts all the rows with Box No.13.

You can test the file by changing the names and numbers in Sheet 1 and seeing the extract change.

Ochimus

[BrightEyes16]

Wow, thanks! I'm impressed.

[Ochimus]

Glad to help.

If it does what you wanted, can you go to the top of this page, find 'Thread Tools' on the RHS, and click "Solved" option, please.

Ochimus