How to refer to cells dependent on a specific variable

  • Thread starter Thread starter Kreller
  • Start date Start date
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting a spreadsheet 3
Formula to add a row 1
lookup function to ignore blanks 1
extracting unique records 1
Cell reference moves 1
formula to pull names out of list 3
Use a hyperlink to display a selection of cells on another sheet (in same workbook) 1
invoice on sheet 1 & data store on sheet 2 automatically 2

Back
Top