Hi I wonder if anyone can guide me please.
I have 3 Sheets that an item moves across depending on its delivery progress, therefore is should only ever be on one Sheet.
I then have a Master Sheet to have an over sight over all items, which will also then be used to gather further data (I will sort that after).
Sheets: Master, New Deliveries, Deliveries Offered, Delivered
<tbody>
</tbody>
I have a VLookup to see if PH001 is on the 'New Deliveries' Sheet - Simple enough:
=IF(VLOOKUP($A3,'New Deliveries'!$A:$A,1,FALSE)=$A3,"New Deliveries")
However if PH001 has now moved to Deliveries Offered I get the error #N/A
So I have incorporated ISERROR
=IF(ISERROR(VLOOKUP(A4,'New Deliveries'!A:A,1,FALSE)=A4),IF(ISERROR(VLOOKUP(A4,'Deliveries Offered'!A:A,1,FALSE)=A4),"Deliveries Offered"),"New Deliveries")
These leads to the result (as per PH004 above) of FALSE.
Once this is worked out I will then duplicate the solution to incorporate the 'Delivered' Sheet.
Any help or better solution to the issue is really appricieated.
I have 3 Sheets that an item moves across depending on its delivery progress, therefore is should only ever be on one Sheet.
I then have a Master Sheet to have an over sight over all items, which will also then be used to gather further data (I will sort that after).
Sheets: Master, New Deliveries, Deliveries Offered, Delivered
PH001 | New Deliveries |
PH002 | Deliveries Offered |
PH003 | |
PH004 | FALSE |
<tbody>
</tbody>
I have a VLookup to see if PH001 is on the 'New Deliveries' Sheet - Simple enough:
=IF(VLOOKUP($A3,'New Deliveries'!$A:$A,1,FALSE)=$A3,"New Deliveries")
However if PH001 has now moved to Deliveries Offered I get the error #N/A
So I have incorporated ISERROR
=IF(ISERROR(VLOOKUP(A4,'New Deliveries'!A:A,1,FALSE)=A4),IF(ISERROR(VLOOKUP(A4,'Deliveries Offered'!A:A,1,FALSE)=A4),"Deliveries Offered"),"New Deliveries")
These leads to the result (as per PH004 above) of FALSE.
Once this is worked out I will then duplicate the solution to incorporate the 'Delivered' Sheet.
Any help or better solution to the issue is really appricieated.