Hi everyone, I've been trying but failing to remember how to solve my
problem. Can you help ?

On one worksheet I have a table composed of member id number, name and
annual salary history (one column for each year eg 2005,2004,2003)
On a second worksheet I have a straight list where member id may be repeated
multiple times in column A, with a date in column B and salary value in
column C

Please can you suggest a formula which would populate my table with the
correct salary history. Column headings on the table do match the values in
column B on the list.

Any help appreciated, many thanks - Harry