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