Thread: VALUE error with index(row.. match(true.. row..
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nastech nastech is offline
external usenet poster
  
Posts: 383
Default VALUE error with index(row.. match(true.. row..
hi, not sure how to setup formula to work. Tried using IF(ISNA variations,
unsuccessful. not sure how to fix value error. thanks.

=IF(A9="","",INDEX(ROW($AB$1148:$AB$1241),MATCH(TR UE,$AB$1148:$AB$1241=$AB9,0))ROW($A$1148))
Reply With QuoteReply With Quote