count if ?? List if?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please let me explain what I need. I hope someone can help

I want cell G2 of my worksheet named January to display the value found in
Worksheet named Jan1 Column F where column B of worksheet Jan1 equals DFW.

any help would be appreciated.
 
Hi

Try something like this:

=INDEX(Jan1!F1:F100,MATCH("dfw",Jan1!B1:B100,0),0)

HTH
Jean-Guy
 

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

sumproduct and IF criteria?? 5
Lookup or VLookup or something else?? 2
Sum If - I think 5
avg ? 16
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel VBA 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Building a reference by concatenating components 4

Back
Top