Hi All

Thanks for looking!

I have a workbook with 2 worksheets named 'Jobs Log' and "Bills".

In column 'K' on the 'Bills' worksheet I need to add a formula to match the reference in column 'A' (still in the 'Bills' worksheet) to the corresponding ref on the 'Jobs Log' in column 'A' and check what is in column 'F'. If column 'F' meets certain criteria it will display 'N/A' or be left blank.

Essentially all I want it to do is auto populate the cell in column 'K' (Bills) with 'N/A' so I know that an invoice does not need to be raised.

If column 'F' on the 'Jobs Log' worksheet was on the same worksheet as the formula it would just be a simple - '=IFERROR(IFS(F2="Cadmium Analysis","N/A"),"")' but of course its not and I cant add it so need to find this work around.

Any help you can offer would be greatly appreciated and if you need anything more from me please just let me know.

Thanks

Stuart