Given
A1: Name B1: Dept C1: Age
A2: Henry B2: 501 C2: 28
A3: Stan B3: 201 C3: 19
A4: Mary B4: 101 C4: 22
A5: Larry B5: 301 C5: 29
how would write a formula to find the age of 'Mary' in dept '101'?
vlookup doesn't seem to support multiple compares.
Thanks
Bookmarks