Need function in formula to only look at first 2 letters

[Jgilmore]

Hey All,

I am looking for a way to insert a function into this formula that will look at the first two letters in ('NCE NCW CDP Forecast'!D:D) part of the formula. The formula itself is correct, but it isn't pulling all of the information because some information in row D:D has more then 2 letters and this formula has to point to 2 letters only to work with the other sheets. E8 in this formula is what D:D is looking for hence, the reason to only see first 2 letters


Thanks for any help you can give.


=SUMIFS('NCE NCW CDP Forecast'!W:W,'NCE NCW CDP Forecast'!C:C,E7,'NCE NCW CDP Forecast'!D:D,E8,'kW Room'!I:I,"kw")/1000

 

[Andrew Poulsom]

Welcome to MrExcel.

You could try changing E8 to E8&"*".

 

[barry houdini]

Hello Jgilmore, welcome to MrExcel

So E8 contains 2 letters and for that condition you want to include all entries in 'NCE NCW CDP Forecast'!D:D that start with those 2 letters? Try using a wildcard like this:

=SUMIFS('NCE NCW CDP Forecast'!W:W,'NCE NCW CDP Forecast'!C:C,E7,'NCE NCW CDP Forecast'!D:D,E8&"*",'kW Room'!I:I,"kw")/1000

 

[Jgilmore]

Thanks Andrew, that worked. When I tried LEFT function it didn't seem to work as well.

 

[Jgilmore]

Thanks for welcome Barry and yes that worked well for this formula. It worked on looking for the last letters as well.