Hi, I'm trying to sort my payments which are a looong list of column B text and column C $ numbers. I'd like to create a series of columns where:
- I enter a keyword at top of each column say column f row 2 - $f$2
- for each line in column f the formula says that if the value in column B for that line equals $f$2, then enter the value in column C for that line
- and ditto for columns g and so on
I can do this with manual entry of name into formula, like '=IF(ISNUMBER(SEARCH("soda ",$b5)),c5, "")' but hoping for a smarter lookup of the column header
Can anyone help me please
- I enter a keyword at top of each column say column f row 2 - $f$2
- for each line in column f the formula says that if the value in column B for that line equals $f$2, then enter the value in column C for that line
- and ditto for columns g and so on
I can do this with manual entry of name into formula, like '=IF(ISNUMBER(SEARCH("soda ",$b5)),c5, "")' but hoping for a smarter lookup of the column header
Can anyone help me please