Vlookup 2 columns - help

Hi,
i am trying to write a lookup function from Col C that looks at Col A and B
and then looks up the match to both cells in a different s/s and returns the
ref #.
Source s/s;
Col A = Band Name
Col B = Manager Name
Col C = reference number
note band name & manager name can appear more than once.
Aim here is result the reference number in Col C.
Thanks
George

=INDEX(Sheet2!$C$1:$C$20,MATCH($A1&$B1,Sheet2!$A$1:$A$20&Sheet2!$B$1:$B$20,0),1)

Entered with Ctrl+shift+enter rather than just enter since this is an array
formula. I assume that the combination of brand name and manager name ties
to only one reference number even it if may appear multiple times in the
lookup sheet.

--
Regards,
Tom Ogilvy


"George" wrote:

> Hi,
> i am trying to write a lookup function from Col C that looks at Col A and B
> and then looks up the match to both cells in a different s/s and returns the
> ref #.
> Source s/s;
> Col A = Band Name
> Col B = Manager Name
> Col C = reference number
> note band name & manager name can appear more than once.
> Aim here is result the reference number in Col C.
> Thanks
> George