Thread: I want to display this as the value, not the cell reference.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Darryl_Neeley Darryl_Neeley is offline
external usenet poster
  
Posts: 17
Default 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?
Reply With QuoteReply With Quote