Excel formula request

%3CLINGO-SUB%20id%3D%22lingo-sub-361172%22%20slang%3D%22en-US%22%3EExcel%20formula%20request%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-361172%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22%22%3EDear%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20a%20project%20I'm%20working%20on%20I%20need%20a%20formula.%3C%2FP%3E%3CP%3EUnderneath%20the%20following%20printscreens%20is%20the%20explanation.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ffilestore.community.support.microsoft.com%2Fapi%2Fimages%2F94486e72-7090-41b1-9c1b-e8abb7407f20%3Fupload%3Dtrue%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ffilestore.community.support.microsoft.com%2Fapi%2Fimages%2F94486e72-7090-41b1-9c1b-e8abb7407f20%3Fupload%3Dtrue%22%20border%3D%220%22%20alt%3D%22Afbeelding%22%20%2F%3E%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ffilestore.community.support.microsoft.com%2Fapi%2Fimages%2F9a7bebdf-269a-46a7-9c88-d4cc08bf3693%3Fupload%3Dtrue%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ffilestore.community.support.microsoft.com%2Fapi%2Fimages%2F9a7bebdf-269a-46a7-9c88-d4cc08bf3693%3Fupload%3Dtrue%22%20border%3D%220%22%20alt%3D%22Afbeelding%22%20%2F%3E%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ffilestore.community.support.microsoft.com%2Fapi%2Fimages%2F77287a8c-2bb9-40fc-bc24-603782b758be%3Fupload%3Dtrue%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ffilestore.community.support.microsoft.com%2Fapi%2Fimages%2F77287a8c-2bb9-40fc-bc24-603782b758be%3Fupload%3Dtrue%22%20border%3D%220%22%20alt%3D%22Afbeelding%22%20%2F%3E%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CEM%3EThe%20used%20information%20is%20fictional%20so%20no%20worries.%3C%2FEM%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20first%20tab%20(Customer%20Names)%20you%20can%20see%20some%20information%20but%20the%20most%20important%20one%20is%20the%20customer%20name.%20From%20my%20input%2C%20the%20information%20in%20the%20first%20tab%2C%20correspond%20two%20of%20the%20company%20names%20with%20the%20information%20in%20the%20second%20tab%20(Customer%20Info).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20output%20I%20would%20like%20to%20see%20is%20this%20information%3A%3C%2FP%3E%3CP%3E-%20the%20customer%20name%20(Company)%3C%2FP%3E%3CP%3E-%20the%20email%20address%3C%2FP%3E%3CP%3E-%20the%20second%20email%20address%3C%2FP%3E%3CP%3E-%20and%20the%20phone%20number%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBecause%20my%20customer%20info%20insn't%20complete%2C%20there%20will%20no%20information%20be%20found%20of%20the%20company%20Linsen%20Parts%20BV.%3C%2FP%3E%3CP%3EEven%20when%20there's%20no%20information%2C%20I%20also%20want%20to%20see%20that%20company%20name%20as%20output%20with%20empty%20fields%20for%20the%20email%20address%2C%20second%20email%20address%20and%20the%20phone%20number.%20So%20you%20can%20see%20which%20company%20still%20needs%20information.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20output%20I%20want%20will%20look%20like%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ELinsen%20Parts%20BV%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B-%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20-%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B-%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3Eapple%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%26gt%3Bemail%20address%26lt%3B%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3C%2FSTRONG%3E%3CSPAN%3E%3CSTRONG%3E%26gt%3Bsecond%20email%20address%26lt%3B%3C%2FSTRONG%3E%3C%2FSPAN%3E%3CSTRONG%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%26gt%3Bphone%20number%26lt%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3Esamsung%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%26nbsp%3B%3C%2FSTRONG%3E%3CSPAN%3E%3CSTRONG%3E%26gt%3Bemail%20address%26lt%3B%3C%2FSTRONG%3E%3C%2FSPAN%3E%3CSTRONG%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3C%2FSTRONG%3E%3CSPAN%3E%3CSTRONG%3E%26gt%3Bsecond%20email%20address%26lt%3B%3C%2FSTRONG%3E%3C%2FSPAN%3E%3CSTRONG%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%26gt%3Bphone%20number%26lt%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20formula%20that%20is%20used%20in%20the%20third%20tab%20doesn't%20work%20for%20this.%20I%20was%20hoping%20someone%20knows%20a%20formula%20or%20any%20other%20way%20to%20do%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%2C%3C%2FP%3E%3CP%3ELuca%3C%2FP%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

Dear everyone,

 

For a project I'm working on I need a formula.

Underneath the following printscreens is the explanation.

 

 

Afbeelding

 

Afbeelding

 

Afbeelding

The used information is fictional so no worries.

 

 

In the first tab (Customer Names) you can see some information but the most important one is the customer name. From my input, the information in the first tab, correspond two of the company names with the information in the second tab (Customer Info).

 

The output I would like to see is this information:

- the customer name (Company)

- the email address

- the second email address

- and the phone number

 

Because my customer info insn't complete, there will no information be found of the company Linsen Parts BV.

Even when there's no information, I also want to see that company name as output with empty fields for the email address, second email address and the phone number. So you can see which company still needs information.

 

The output I want will look like this:

 

Linsen Parts BV             -                                                  -                                                       -    

apple                     >email address<                   >second email address<           >phone number<

samsung                >email address<                 >second email address<           >phone number<

 

 

The formula that is used in the third tab doesn't work for this. I was hoping someone knows a formula or any other way to do this.

 

 

Kind regards,

Luca

0 Replies