problem with creating a query

[funi.t]

Let me take you through my problem again.
I have two tablesStore units(T1) and Master shipping table(T2).
I have to search the waybillnr that is on T1 on T2.If the waybillnr is availible in both T1 and T2,Access should give me the corresponding shipping ID(found in the shipping master table).
If not it should say"Not on List").



I can do it on excel but not on access
Arrays:
A2=waybill T1
B2=waybill T2
C2= shpment ID

Here is an example:
D2=IF(ISNA(VLOOKUP(A2,$B2:B$282871,FALSE)),"not on list","on list")
E2=IF(D2="on list",C2,"not shipped")

Please help

[jzwp11]

You say that the waybill number is in both tables but you do not say what the relationship is between the two tables. For each waybill in Store Unit (T1) can there be many related records in the Master Shipping table (T2) or is it the other way around (one master shipping record to many store unit records)?