Order Status with Lookup

Hi all, was hoping to get help with the following status issue. 

I have a table called Take Off Groups, which relates to the view below. Sarah_Keown_0-1656666127205.png

Each of these records relates to two other tables; Material Take Offs and Order Details. 

Take Offs that appear as 'Drawn Off', contain material that has been request by User Group A lets say, material requested here needs to be ordered by User Group B. I want to put a status in the Take Off Group table to say whether or not that material has been 'Ordered' or 'Received in Full'. 

Example; 

Sarah_Keown_1-1656666259154.png

The above 'Overall Status' of this would be Received in full as all of the related order details are saying that. 

I know this will probably require a lookup formula, but just don't know how to execute without errors because I'm looking up through a list of the Request Status' 

0 1 58
1 REPLY 1

I'm not sure if I fully understand your data structure clearly. First of all, what is the expression (LOOKUP) that's producing error?

Top Labels in this Space