Formula to give a text result based on 2 arguments

[Danoz]

Hi,

I want to find a text result in col C, based on a number reference in col and a text reference in col B.

Is there a formula i can use for this?

I have tried lookup and if (only uses one argument) and sumifs (ignores text result)

Thanks for any help.

 

[Sandeep Warrier]

Hi & welcome to the Board,

How about something like

Excel Workbook
	A	B	C	D	E	F	G
1	Number	Text	Result Col		Number	Text	Result Col
2	68	ABC	FBEOF		29	ABC	UICHK
3	10	DEF	OIAUO
4	79	GHI	DXQKI
5	29	ABC	UICHK
6	81	DEF	HSZLD
7	78	GHI	MEHHF
8	61	ABC	TARHH
9	45	DEF	CTWZV
10	17	GHI	EATYD
11	4	ABC	GYYUN
12	89	DEF	XBXZO
13	40	GHI	GFHXH
Sheet1

Excel 2003

#VALUE!

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

 

[Danoz]

Thanks for your reply.

Thats perfect, works a treat, thankyou very much.