Need of a Formula

[4hoteliers]

In a sheet I have in Column A, the travel agent name. In column B should have the type of the company. How can i create a formula that will add in column B the type of the company.
Trying to use the if but no luck.
The column A have these 10 names (Hotelbeds, Gta, Welcomebeds, Hotusa, Webbeds, Sunhotels, Booking, Expedia, Agoda).
In column B should have their types which are:
Hotelbeds, Gta, Welcomebeds, Hotusa, Webbeds, Sunhotels = WEB TO
Booking, Expedia, Agoda = IDS
Thank you very much for your help

 

[Yongle]

please supply some sample data showing what is in column A and what should appear in column B for each row
Here is the site tool to upload worksheet data

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

 

[4hoteliers]

please supply some sample data showing what is in column A and what should appear in column B for each row
Here is the site tool to upload worksheet data

XL2BB - Excel Range to BBCode

Excel 'mini-sheet' in messages - XL2BB Although experts prefer to read your description and question instead of working in your actual file to solve your problem, there are times that it is difficult to explain an issue without providing actual...

www.mrexcel.com

Segment is in Column A and Client is in Column B. In Column C ned to have a formula that will permit me to check if the Client is associated correctly with Segment

Segment	Client
WEB TO	HOTELBEDS
IDS	EXPEDIA
IDS	BOOKING
WEB TO	HOTELBEDS
IDS	BOOKING
IDS	EXPEDIA
IDS	EXPEDIA
IDS	AGODA
IDS	BOOKING
WEB TO	GTA
IDS	BOOKING
IDS	BOOKING
WEB TO	GTA

 

[Yongle]

Is there only ONE segment associated with each Client?

 

[4hoteliers]

Is there only ONE segment associated with each Client?

Yes, only one segment is associated with each client.

 

[Yongle]

Here is one way

The formula in column C looks up the table (in columns G:H) to see if values in column A are correct
=VLOOKUP(B2,$G$2:$H$100,2,0)=A2

The formula in column D uses looks up the client name in the table and returns segment
=VLOOKUP(B2,$G$2:$H$100,2,0)

The table could be placed in a different sheet
The lookup range is longer than the actual range to allow for more clients to be added later
The lookup range is absolute (does not change when copied down)

Book1
	A	B	C	D	E	F	G	H
1	Segment	Client	TEST	SEGMENT LOOKUP			Client	Segment
2	WEB TO	HOTELBEDS	True	WEB TO			AGODA	IDS
3	IDS	EXPEDIA	True	IDS			BOOKING	IDS
4	IDS	BOOKING	True	IDS			EXPEDIA	IDS
5	WEB TO	HOTELBEDS	True	WEB TO			GTA	WEB TO
6	IDS	BOOKING	True	IDS			HOTELBEDS	WEB TO
7	IDS	EXPEDIA	True	IDS
8	IDS	EXPEDIA	True	IDS
9	IDS	AGODA	True	IDS
10	IDS	BOOKING	True	IDS
11	WEB TO	GTA	True	WEB TO
12	IDS	BOOKING	True	IDS
13	IDS	BOOKING	True	IDS
14	IDS	GTA	False	WEB TO
Sheet3

Cell Formulas
Range	Formula
C2:C14	C2	=VLOOKUP(B2,$G$2:$H$100,2,0)=A2
D2:D14	D2	=VLOOKUP(B2,$G$2:$H$100,2,0)

 

[4hoteliers]

Here is one way

The formula in column C looks up the table (in columns G:H) to see if values in column A are correct
=VLOOKUP(B2,$G$2:$H$100,2,0)=A2

The formula in column D uses looks up the client name in the table and returns segment
=VLOOKUP(B2,$G$2:$H$100,2,0)

The table could be placed in a different sheet
The lookup range is longer than the actual range to allow for more clients to be added later
The lookup range is absolute (does not change when copied down)

Book1
	A	B	C	D	E	F	G	H
1	Segment	Client	TEST	SEGMENT LOOKUP			Client	Segment
2	WEB TO	HOTELBEDS	True	WEB TO			AGODA	IDS
3	IDS	EXPEDIA	True	IDS			BOOKING	IDS
4	IDS	BOOKING	True	IDS			EXPEDIA	IDS
5	WEB TO	HOTELBEDS	True	WEB TO			GTA	WEB TO
6	IDS	BOOKING	True	IDS			HOTELBEDS	WEB TO
7	IDS	EXPEDIA	True	IDS
8	IDS	EXPEDIA	True	IDS
9	IDS	AGODA	True	IDS
10	IDS	BOOKING	True	IDS
11	WEB TO	GTA	True	WEB TO
12	IDS	BOOKING	True	IDS
13	IDS	BOOKING	True	IDS
14	IDS	GTA	False	WEB TO
Sheet3

Cell Formulas
Range	Formula
C2:C14	C2	=VLOOKUP(B2,$G$2:$H$100,2,0)=A2
D2:D14	D2	=VLOOKUP(B2,$G$2:$H$100,2,0)

Thank you very much. Your suggestion is working perfect!!!