Vlookup & Countif help

1) D7 shouldn't change when you change B28 to something else because C28 is "cash" so changing B28 will only change a value in column C above, the "cash" column.

2) The formula is looking at the first 6 characters, so as long as the variations appear AFTER the first 6 characters, they will be considered matches.

3) If the data range changes, be careful as you paste. Change the formulas to use a longer a "default" range of cells, maybe make it B28:B200...that should be sufficient, yes?

Another option would be to adapt the possible solution you were given on the previous thread, ie:

C7:
=SUMPRODUCT(--ISNUMBER(MATCH($B$28:$B$60,INDEX($I$7:$L$14,MATCH($B7,$I$7:$I$14,0),0),0)),--($C$28:$C$60=C$6))
copied across C7:E14

the above uses the term in B7 and searches for all known variants thereof (as stipulated by table in I:L) in the main range B28:B60... the alteration from before is the addition of the Cash/Credit/Operator check.