count if ?? List if?
 

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.

count if ?? List if?
 

Hi

Try something like this:

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

HTH
Jean-Guy

"Tammy" wrote:

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.