Working with multiple worksheets

  • Thread starter Thread starter Balaji K. Arige
  • Start date Start date
B

Balaji K. Arige

This is probably very simple but i am struggling with this. I have a
workbook where one sheet will be updated on a monthly basis and i want the
sheet preceding it to capture its outputs. A few things i need it to capture
is to check if Col B has a specific value and if yes check the value of the
cell adjacent to it and count this if it is a Yes or a No.

Please help!

BK
 
It sounds like VLOOKUP will work for you. Look in the help index for
VLOOKUP.
 
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

Counting unique values in multiple columns 4
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Excel Move or Copy Stopped Working? 0
Newbie for starters with excel, I am needing to transfer info fromsheet2 to the universe sheet. 1
same formula and cells for different worksheets 1
How to Output Data from Variable Ranges in Multiple Sheets into 1Report; Yikes 3
Sum multiple lookup values 7
Access Dcount (multiple criteria) 3

Back
Top