I want to display this as the value, not the cell reference.
 

=IF(D9="","",IF(E9="","",IF(F9="","",ADDRESS(MATCH (F9-E9,BWP!A1:BWP!A45,0),MATCH(D9,BWP!A1:BWP!AO1,0),4) )))

Instead of displaying A8, how would I go about getting this to display what
is contained within A8? What would I replace the ADDRESS function with? Or
what would I add on to make it display the value instead?

I want to display this as the value, not the cell reference.
 

Try this:

=IF(OR(D9="",E9="",F9=""),"",INDEX(MATCH(F9-E9,BWP!A1:A45,0),MATCH(D9,BWP!A1:AO1,0))

When referencing a range on another sheet it's not necessary to repeat the
sheet name:

BWP!A1:BWP!A45

BWP!A1:A45

--
Biff
Microsoft Excel MVP


"Darryl_Neeley" wrote in message
...
=IF(D9="","",IF(E9="","",IF(F9="","",ADDRESS(MATCH (F9-E9,BWP!A1:BWP!A45,0),MATCH(D9,BWP!A1:BWP!AO1,0),4) )))

Instead of displaying A8, how would I go about getting this to display
what
is contained within A8? What would I replace the ADDRESS function with? Or
what would I add on to make it display the value instead?

I want to display this as the value, not the cell reference.
 

It's coming up as "#REF!". What's this pertaining to?

And thank you for the little tip with the reference.

"T. Valko" wrote:

Try this:

=IF(OR(D9="",E9="",F9=""),"",INDEX(MATCH(F9-E9,BWP!A1:A45,0),MATCH(D9,BWP!A1:AO1,0))

When referencing a range on another sheet it's not necessary to repeat the
sheet name:

BWP!A1:BWP!A45

BWP!A1:A45

--
Biff
Microsoft Excel MVP


"Darryl_Neeley" wrote in message
...
=IF(D9="","",IF(E9="","",IF(F9="","",ADDRESS(MATCH (F9-E9,BWP!A1:BWP!A45,0),MATCH(D9,BWP!A1:BWP!AO1,0),4) )))

Instead of displaying A8, how would I go about getting this to display
what
is contained within A8? What would I replace the ADDRESS function with? Or
what would I add on to make it display the value instead?

I want to display this as the value, not the cell reference.
 

Ooops!

Sorry, my mistake.

Try this:

=IF(OR(D9="",E9="",F9=""),"",INDEX(BWP!A1:AO45,MAT CH(F9-E9,BWP!A1:A45,0),MATCH(D9,BWP!A1:AO1,0)))

--
Biff
Microsoft Excel MVP


"Darryl_Neeley" wrote in message
...
It's coming up as "#REF!". What's this pertaining to?

And thank you for the little tip with the reference.

"T. Valko" wrote:

Try this:

=IF(OR(D9="",E9="",F9=""),"",INDEX(MATCH(F9-E9,BWP!A1:A45,0),MATCH(D9,BWP!A1:AO1,0))

When referencing a range on another sheet it's not necessary to repeat
the
sheet name:

BWP!A1:BWP!A45

BWP!A1:A45

--
Biff
Microsoft Excel MVP


"Darryl_Neeley" wrote in message
...
=IF(D9="","",IF(E9="","",IF(F9="","",ADDRESS(MATCH (F9-E9,BWP!A1:BWP!A45,0),MATCH(D9,BWP!A1:BWP!AO1,0),4) )))

Instead of displaying A8, how would I go about getting this to display
what
is contained within A8? What would I replace the ADDRESS function with?
Or
what would I add on to make it display the value instead?