Hi
Hoping somebody can help with a slight problem I'm encountering
I have a sheet of approximately 850 employees that I need to cross check against a data file supplied by an external stakeholder, I have been using a simple MATCH formula to check whether the colleagues' employment number and log in ID appears on the external data file, which works well on the whole however the raw data file supplied by the external company is a mess in that the required information isn't consistently in the same column. Most employment numbers appear on column D for example however the data may also appear in other columns, the same applies to the log in ID.
I only need to return a True or False result on whether the employee number and log in ID are on the raw data file rather than lookup any additional information
I've tried using an IF(COUNTIF formula to check a range of columns which works, however the raw data file contains c9000 rows, with data spread inconsistently across 6 or 7 columns, and I need to run the check on 850 odd colleagues so as you can imagine the formula is pretty labour intensive.
Does anyone have any thoughts on how I could complete the check however with a more manageable formula
Hope that all makes sense
Thanks in advance for any thoughts and suggestions
PS I'm not able to request the external stakeholder reformat their data as it's an extract directly from their system
Twaddy
Bookmarks