look up X and return a header Y
hello Biff thanks...
could you explain the use of 1/ in the lookup vector?
I completly ommited that!
Anyway now i have two reports I can compute (pivot table and this) so
it helps to double check :)
M
Biff wrote:
After trying all combinations of formulas I have given up and used a
pivot table!
No need to torture yourself!
..............B..............C..............D
1........M vs S......S vs X......G vs K
2.........20/06.......21/06........22/06
3.........Mario.......Peter.........Mario
A10 = lookup value = Mario
=LOOKUP(2,1/(B3:D3=A10),B1:D1)
Biff
"MMuscat" wrote in message
oups.com...
Hi,
I have a list of referees whereby some names could be repeated and I
want to find the corresponing date and match a referee has last
officiated in.
for example:
Match: M vs S | S vs X | G vs K
Date: 20/06 | 21/06 | 22/06
Ref: Mario | Peter | Mario
I want to search the last match Mario has refereed in and return G vs
K.
I tried using offset, match and lookup but I am not really familiar
with these formulas sa I rarely use them.
Regards,
Mark
|