count if ?? List if?

T

Tammy

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.
 
P

pinmaster

Hi

Try something like this:

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

HTH
Jean-Guy
 
Top