Simple =If formula

[Bramleroy]

Not sure why I am blanking on this one....

I need to Paste:

ACD

ACD

ACD

ACD

BLT

BLT

BLT

BLT

BOI

BOI

BOI

BOI

BMR

BMR

BMR

BMR

<tbody>
</tbody>

Into a column, lets say column A. I need the column to change the ACD,BLT, BOI, BMR to their true customer names. The abbreviations might be different every time so would I use a Vlookup or an =If formula?

ACD = C114550 Whole Foods Market : ACD : Academy
BLT = C127984 Whole Foods Market : RM : CO: Basalt : BLT : Roaring Fork
BOI = C130291 Whole Foods Market : BOI : Boise : South Broadway
BMR = C114552 Whole Foods Market : BMR : Belmar : Wadsworth Blvd


There will be more just need help with the initial formula. Thanks for the help!

 

[kevinb11]

Excel Workbook
	A	B	C	D	E	F	G
1	ACD	C114550	Whole	Foods	Market	:	ACD : Academy
2	BLT	C127984	Whole	Foods	Market	:	RM : CO: Basalt : BLT : Roaring Fork
3	BOI	C130291	Whole	Foods	Market	:	BOI : Boise : South Broadway
4	BMR	C114552	Whole	Foods	Market	:	BMR : Belmar : Wadsworth Blvd
5
6
7	ACD	C114550	Whole	Foods	Market	:	ACD : Academy
Sheet1