Is the formula returning an error message? If so, which one? Or are
you getting an incorrect result?

In article ,
jimswinder wrote:

Well...it worked in my very simple test spreadsheet...but not my actual one
where I have several different worksheets....one where I am putting the
formula and another where it is looking for/at the data. I don't know how I
could explain or show you what I am actually wanting to do without sending
you the spreadsheet.