Forum Discussion
Mz_TLo7631
Oct 05, 2023Copper Contributor
auditing rates
I was wondering if anyone can help me verify the accuracy of union hourly rates from employee data entered on spreadsheet ABC, against my legend which is located on spreadsheet XYZ, (within the same ...
SergeiBaklan
Oct 05, 2023Diamond Contributor
In general something like
=XLOOKUP(Department&JobTitle, XYZ!Department&XYZ!JobTitle, XYZ!Rate)
shall work
Mz_TLo7631
Oct 05, 2023Copper Contributor
this formula is not taking into consideration my range of that information to compare it to on the spreadsheet ABC to compare my legend against.
when i type in this formula i get an error message #NAME?.
when i type in this formula i get an error message #NAME?.
- SergeiBaklanOct 07, 2023Diamond Contributor
Perhaps you may share small sample file or at least screenshot to illustrate how your data is structured exactly.
- Mz_TLo7631Oct 07, 2023Copper Contributor
- HansVogelaarOct 07, 2023MVP
You don't need to enter the rate on the ABC sheet - you can use a formula to look it up.
See column K on the ABC sheet.
I used this to highlight the errors in column J.