LinkBack URL
About LinkBacks
I am trying to have a formula that will return a value on another column based on the last entry for the search item.
The one i have is KIND of working, but with errors.
Can anyone suggest a better/easier way?
I am trying to have a formula that will return a value on another column based on the last entry for the search item.
The one i have is KIND of working, but with errors.
Can anyone suggest a better/easier way?
Hi,
Try
in C200 copied downFormula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
problem with this example is "richard.pigden" ... it returns weird value
another inconsistent return is ken.mcallister.. it should be the value from c166
I think this part should be change
($C$1:$C$190=F200) it should be ($C$2:$C$190=F200)
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
it seems that it worked!
but why would it mess my results?!
Because the range was off by 1. Instead of C1 it should be C2Originally Posted by cristian.ene
it seems that it worked!
but why would it mess my results?!
Nice catch AlKey .. I was scratching my head, too.
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks