comparing and automatic add data

Hello everyone,
I made a excell form with two sheets.
If i fill in the company row A and driver B it automitcly fills row c with licence plate from sheet 2.
Now is my question is it possible that if the driver or company or licenceplate doesn't excist in sheet 2, it fills it in from sheet 1?

I attached a form with the sample.
Greet Roland

A cell can either contain a formula or a manually typed value, not both.

That being said, you can use B1:B3 for the manual entries and then C1:C3 for the formulas to return whatever is missing.

Like this:

C1 =IF(B1="",INDEX(Blad2!A2:A13,INDEX(MATCH(B2&B3,Blad2!B2:B13&Blad2!C2:C13,0),0)),"")
C2 =IF(B2="",INDEX(Blad2!B2:B13,INDEX(MATCH(B1&B3,Blad2!A2:A13&Blad2!C2:C13,0),0)),"")
C3 =IF(B3="",INDEX(Blad2!C2:C13,INDEX(MATCH(B1&B2,Blad2!A2:A13&Blad2!B2:B13,0),0)),"")

i correct your, to ; But the formula says #naam . I also think you misunderstood me. If i fill in B1 and B2, information of B3 is in sheet 2. then the information is already in sheet 2.
If i fill B1 and B2. and the information of B3 is not in sheet 2, i can put the new information in C3 . Is it possible that the information make a copy to sheet 2. With something like? IF C3=treu; copy B1 and B2 and C3 to a new row in sheet 2.

At first thanks for your reply

What you are asking for is not possible through the use of formulas or built in functions. It may be possible with VBA but I cannot help there.

Thanx for your answer. I give it another try at the acces group