How to refer to cells dependent on a specific variable

K

Kreller

I'm making a contact list where I in sheet 2 want to take out specifi
details from sheet 1 dependent on whether there is arranged a meetin
with the company. In sheet 1 each company has a row and when i tick of
"Meeting" from a validation list, I have put under contact result fo
each company, I want a function that can take the relevant inf
(company name, contact person, date of contact, etc) and put them i
sheet 2. Do you have a suggestion?
 
Top