Return multiple cell references based on a search criteria

Hi is it possible to return multiple cell references there are in a column that. What I need to do is do find a value based on a search criteria, once found then look down the column it is in to find all cells that have values and return references to those cells - see attchment for example

I want to be able to search for Apr then look down that column ie. D and return the cells D2, D4 & D6 references so I can do some calculations on them.

I was trying to do with a VLOOKUP for the Apr search but then you can only return one cell ref by then offsetting a certain number of rows, etc.

Any advice as to how to do would be grateful, or if it is not possible

Originally Posted by ruddocg

Hi is it possible to return multiple cell references there are in a column that. What I need to do is do find a value based on a search criteria, once found then look down the column it is in to find all cells that have values and return references to those cells - see attchment for example

I want to be able to search for Apr then look down that column ie. D and return the cells D2, D4 & D6 references so I can do some calculations on them.

I was trying to do with a VLOOKUP for the Apr search but then you can only return one cell ref by then offsetting a certain number of rows, etc.

Any advice as to how to do would be grateful, or if it is not possible

Hi,

Would SumProduct be able to do the final calculations on the cells? - or do you want separate calculations for separate cells?

---