• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 60
  • Last Modified:

get row value

I am using the formula to get the matching row/value in a column it works fine until there are like values. I need to get the value to populate cells in another range.
see book attached
1 Solution
Glenn RayExcel VBA DeveloperCommented:
I don't see how this function works at all, even if there are discrete values in column BA.  Is this function copied down in order to return the additional values in BG and BH?  You'll need to provide more details here.

One problem is that - if the SUMPRODUCT function returns a zero value - that makes the row argument for the INDEX function zero.  When that happens, you'll get an invalid result.  But, instead of Excel throwing an error (which it should), it can give you unusual results.  Sometimes, it gives you the row on which the INDEX function resides - sometimes it's a value one less.
SvgmassiveAuthor Commented:
so what's the solution? is there an alternative?
Glenn RayExcel VBA DeveloperCommented:
I'm still not sure what you are trying to achieve here.  The two lists in BG and BH are identical and there are no values in BB, which I assume you want to return.  Just need to know the proper relationships and what they mean.

Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now