Forum Discussion
Excel formula to identify unreturned uniform
Dear community I work in a school and through attempting to get more processes digitised, I am adapting my spreadsheet for passes from school and borrowed uniform. Sometimes students forget to re...
In general one of lookup functions shall be used, depends on your Excel version (XLOOKUP, VLOOKUP, INDEX/MATCH).
An issue is that you have no unique records in Borrowed uniform, same combination of Reg Group and Full Name could return bot Yes and No, e.g.
Something else (Date?) is required to identify exact combination.
- Hi Sergei
Yes there won't be any unique values, and some students may appear more than once on the borrowed uniform list. I need something to identify if there are any items that the student has not returned. I can't specify a date to look up as I won't know the date that the issue will be from.
The information provided in the sample file is all the relevant information. Nothing else matters regarding identifying an issue.You better know business logic, but without such identification you can't link data in both tables. More exactly you can, but in some cases result will be incorrect.
