Lookup and count?

  • Thread starter Thread starter Bobby
  • Start date Start date
B

Bobby

I can't figure out how to do something.

I have a list of names on one sheet and I want to lookup another sheet,
compare each name with a list of names and when a match is found, check the
number of tasks that person has done (which is stored in an adjacent cell).
I don't know how to do this. Any ideas?

Cheers.

Bobby
 

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

How to replace text with numbers? (formula) 3
Lookup two columns 3
lookup and return column number 2
Sumproduct function allow a lookup for one Date to check if it fallsin Date Range in other table 9
Excel lookup across entire workbook 1
Counting acceptances and rejections 3
list items from one table in another table based on value in first table 2
...lookup? 3

Back
Top