I'd like tou extract the data related to the values in the first column(A).
For instance, when I like to find the shift data related to b and c, I can use VLOOKUP and I will get 3 and 5 as a result.
Now I would like to find the attendance data. For instance, I want to have the attendance data for b and c, this should give 4 and 6 as result. Which formula could help me solve this?
a Shift 1
Attendance 2
b Shift 3
Attendance 4
c Shift 5
Attendance 6
d Shift 7
Attendance 8
e Shift 9
Attendance 10
Bookmarks