Hi, i have a sheet with two tables
Here i have columns like Lot No., Storage Bin(A Section), Location Availability ?
Here columns are Lot No., Status,
What i want help with is in Table 1 Location Availability ? i want top put in an expression where if the same lot no. as in Table 1 in Table 2, where Status is completed, i want the expression return data as available, or Unavailable.
I dont mind if i get a Google Sheet Expression also
Can anyone help me in this regard.