Simple but hard

[yeshuawatso]

I need help! Let me start from the begining, I have a workbook that
displays my employees statistics all on one page from the previous day.
What I need it to do is to search the agents personal status sheets for
the previous day's date. Today()-1. After it finds the date go to a
certain cell in the same row. Let's say column H. Then display the data
in that cell. I've got it to find the date but i cant get it to display
the cell with the data. Any Ideas?

 

[Don Guillett]

assuming you used match to find the date address, then use offset to find
the value in H

 

[yeshuawatso]

But that's the thing I have only got it to find the date not the
address. I need to know how to find the address then offse it to that
cell.

 

[Don Guillett]

It's customary for you to copy/paste your coding efforts here for comments.

 

[yeshuawatso]

This is what iv'e done so far it tells me if the date is there or not
there.

=IF(ISNA(MATCH((TODAY()-1),'[Aaron Agent Tracking.xls]Completion
Rates'!$B$5:$B$13,0)),"Is not Availible","here")

This one just matches the data and gives me the number 8 for some odd
reason.

=MATCH((TODAY()-1),'[Aaron Agent Tracking.xls]Completion
Rates'!$B$5:$B$45)

 

[JulieD]

Hi

from reading your original question it seems to me that you should be using
a VLOOKUP statement or INDEX / MATCH combination .. if you want to find
something in column B and return the associated value in column H

e.g.
=IF(ISNA(VLOOKUP((today()-1),'[Aaron Agent Tracking.xls]Completion
Rates'!$B$5:$H$13,7,0)),"",VLOOKUP((today()-1),'[Aaron Agent
Tracking.xls]Completion
Rates'!$B$5:$H$13,7,0))

or have i misunderstood the question?

Cheers
JulieD

 

[Aladin Akyurek]

This is what iv'e done so far it tells me if the date is there or no
there.

=IF(ISNA(MATCH((TODAY()-1),'[Aaron Agent Tracking.xls]Completio
Rates'!$B$5:$B$13,0)),"Is not Availible","here")

This one just matches the data and gives me the number 8 for some od
reason.

=MATCH((TODAY()-1),'[Aaron Agent Tracking.xls]Completio
Rates'!$B$5:$B$45)

In X1 or in some other cell:

=MATCH((TODAY()-1),'[Aaron Agent Tracking.xls]Completio
Rates'!$B$5:$B$13,0)

In X2...

=IF(ISNUMBER(X1),INDEX('[Aaron Agent Tracking.xls]Completio
Rates'!$H$5:$H$13,X1),"Not Found"

 

[yeshuawatso]

thanks you guys it finally worked. Aladin your a genius!