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