Hi all - i've tried a couple of adaptations of a formula i was given here, but it isn't doing what i need to do.
column B holds numbers: 1 - 5
column D holds cells with text
Column H holds quantities for each of the text cells in column D
I am trying to use a static cell: U8 to search column D for the text CURD and if column B in same row as curd = 2 return the value on the same row in H
hope this makes sense. I can't use a formula to drag it down alongside the source data as i need to build a summary sheet.
TIA
column B holds numbers: 1 - 5
column D holds cells with text
Column H holds quantities for each of the text cells in column D
I am trying to use a static cell: U8 to search column D for the text CURD and if column B in same row as curd = 2 return the value on the same row in H
hope this makes sense. I can't use a formula to drag it down alongside the source data as i need to build a summary sheet.
TIA