Index/Match/creating table help......

[IGinc]

GIA
EGL Intl.
EGL Other
EGL USA
IGI
HRD

Notes--

IF Gia the image src is "a"

If it is Any of the 3 EGL it is "b"

If IGI it is "c"

for HRD "d"

I recall if I make the right table and insert I believe the index match formula, it will pull the data from the table, and put the url in the row/column I need it, thanks in advance!

Kindly label the formula so I know what data needs to go where and how to manipulate, thanks a bunch!!!

Mike

 

[IGinc]

Anybody?

 

[jbeaucaire]

Like so.... the two-column table is demonstrated in columns A:B. The values in column F are spotted in column A and results returned from column B into column G using the two sample formulas shown:

Excel Workbook
	A	B	C	D	E	F	G	H
1	Code	URL
2	GIA	a				GIA	a
3	EGL Intl.	b				IGI	c
4	EGL Other	b				GIA	a
5	EGL USA	b				EGL USA	b
6	IGI	c
7	HRD	d
8
Sheet3

 

[IGinc]

thank you worked just as needed.