Ciao Ciao
I am struggling to do something simple, but it seems not it does not want to work. I have two tables, one for invoice and one for values. Both of them has the same referance, the Purchase order number(POA). I do not want to type my values over and over for each table, i only want to type the values in the value table and then it must automatically update in the field(using the POA number). I tried using the below. Can you please help, thank you allot!
=DLookUp([Unit list]![POA];[Unit list];[Aermec order]), but i get the #name? error
Unit list is the one with the values
Aermec orders is the field where the reference/lookup will be, the POA number
I am struggling to do something simple, but it seems not it does not want to work. I have two tables, one for invoice and one for values. Both of them has the same referance, the Purchase order number(POA). I do not want to type my values over and over for each table, i only want to type the values in the value table and then it must automatically update in the field(using the POA number). I tried using the below. Can you please help, thank you allot!
=DLookUp([Unit list]![POA];[Unit list];[Aermec order]), but i get the #name? error
Unit list is the one with the values
Aermec orders is the field where the reference/lookup will be, the POA number