Get a list from multiple cells returned into a single cell based on contents of two other cells
Hello there, I hope someone is able to help. I have a problem I am trying to solve involving two sheets.
I have attached screenshots, which I hope will be useful in understanding what I am trying to achieve here.
Take a look at the formula in H7 on the Void Tracker. It’s nearly there, but it isn’t quite working. What I’m trying to get it to do is to look at column B in the property list and find all the properties listed as Void for all the cells in Column D with the address “99 The Avenue” in column D and return all the relevant rooms in column E. So, what I want it to do, is return me a list of “Room 2 Room 3 Room 4” in Cell H7 of the void tracker, as those rooms are listed as Void in column B under that address. It should not return Room 1 as that is not listed as Void.
However, it isn’t doing what I want, as you can see. The cell value that it is retuning is E14 of the Property list, but it’s just retuning that cell value four times.
If anyone can help, I’d greatly appreciate it.
Many thanks.
Hello there, I hope someone is able to help. I have a problem I am trying to solve involving two sheets.I have attached screenshots, which I hope will be useful in understanding what I am trying to achieve here. Take a look at the formula in H7 on the Void Tracker. It’s nearly there, but it isn’t quite working. What I’m trying to get it to do is to look at column B in the property list and find all the properties listed as Void for all the cells in Column D with the address “99 The Avenue” in column D and return all the relevant rooms in column E. So, what I want it to do, is return me a list of “Room 2 Room 3 Room 4” in Cell H7 of the void tracker, as those rooms are listed as Void in column B under that address. It should not return Room 1 as that is not listed as Void. However, it isn’t doing what I want, as you can see. The cell value that it is retuning is E14 of the Property list, but it’s just retuning that cell value four times.If anyone can help, I’d greatly appreciate it. Many thanks. Read More