Hey all,
I'm trying to do a sort of query operation to get the apropriate data based
on two rows that need to be matched i.e. A1=Days of the week B1=Task 1 C1=Pay

so when I populate another spreadsheet with days in the column and tasks in
the A row I can get the pay for each cell associated with the day.
this is the formula I came up with but I can't seem to get it to work?

=OFFSET(A1:B1,MATCH("Thursday*" & "1",A2:A58:B2:B58,0),2) ?????