Conditional Nested if function

[dave84dd]

Hello,

I have a tricky, well, I think it is tricky formula I need to write.

The idea is that any item that starts with "A" and number after "B" and numbers after "C" and numbers after "E" and numbers after or finally "K" and numbers after I would like the letter returned. Everything whatever the combination is would be ignored.

I was thinking a nested IF AND function however I haven't been able to get it to work therefore I'm reaching out to the Excel guru's of this forum.

[TABLE="class: grid, width: 354"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Number[/TD]
[TD]Desired results[/TD]
[TD]Notes about Results[/TD]
[/TR]
[TR]
[TD]A08071-H[/TD]
[TD]A[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]B08054[/TD]
[TD]B[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]CCA-TBA[/TD]
[TD] [/TD]
[TD]This items should be ignored[/TD]
[/TR]
[TR]
[TD]C08071[/TD]
[TD]C[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]E04534[/TD]
[TD]E[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]K40585[/TD]
[TD]K[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]HLA[/TD]
[TD] [/TD]
[TD]This items should be ignored[/TD]
[/TR]
</tbody>[/TABLE]

As always thanks for the help in advance.

 

[JoeMo]

Copy B2 down.

Excel Workbook
	A	B
1	Number	Result
2	A08071-H	A
3	B08054	B
4	CCA-TBA
5	C08071	C
6	E04534	E
7	K40585	K
8	HLA
Sheet1

 

[dave84dd]

Perfect! You rock! Thanks....I knew I was on the right path.....just couldn't get around the bolder blocking the road....