Match a value against a date and enter the matched value




hi
many thanx for the solution
I closed the other messages before came here because no solution was provided unlike yours
the only thing is the match part need to work

What do you mean by the ' match part ' ...???

=IF(DAY(AW1)<10,"",IF(Y9=9,BF1,""))
if the day is 14 its paste 5 in Y10 under Y9
sud actually be blank because bf1 does not match with Y9



Thanks for your Like
Does it mean the last formula has solved your question ?

Hi
many thanx
This is working like a dream and solves my issues
I am really grateful for the solution
Regards
rajan

Pleased to hear you could solve your question
Thanks a lot for your Thanks ... AND for the Like

Yes thank you so much
May I trouble finally for last formula
Need to check for lucky and unlucky numbers
attaching table
once this is complete, I will share the loshu grid with you if you would like to have it for your researck
Rajan


As soon as I have a moment ... will look into the " Lucky  UnLucky " question

Hi
many thankx much appreciated
Regards
Rajan

Thanks a lot for the combined 3 challenges ... to build your array formulas ...
Time for me to take some aspirin
Attached is your V2 file ...
Hope this will help

Hi Sir
Amazing solution
My humble apologies for being the cause of you having to take aspirin
I am extremely grateful for the help
Sir do let me know if this grid will be of use to you
Regards
Raj

Very pleased to hear your " lucky and unlucky numbers " issue is now fixed ...
Quite honestly ... had never heard of the " Loshu Grid  Magic Square " .... before your question ...
Thanks to you ... have learned a lot :
It is coming from ancient China, ... it is at least 4'000 years old ... its origin is a tortoiseshell which had a 3×3 square ...
and experts, like you, use it to understand life ...
Wish you all the Best


Hi
Many thanx for the kind words
The grid did originate from China
Now in India its used a branch of numerology
Have started learning to use the grid
Thank you once again
Rajan

Thanks for for Thanks
Hope you will soon become a wellknown Expert in this ART ...
Take Care

Hi Sir
Also I would like to thank for all your help and guidance in helping find solutions
The most is that I am also learning how to use and apply formulae
At any time if you would like a grid made for you
I will be most honored to do
Once again
Many thanx and regards
Rajan

Greetings Sir
I just discovered that I have a further challenge that in the example AN1 plus AO1 , the sumtotal would be 5, we need to check in row R12 if it matches, pate the the value into R13 I removed the old formula from R13
May you please help with a formula to do the above
many thanx
rajan 
Hello,
It seems to me the formula required for cell R13 ... is, in fact, ... identical to the one you already have in cell Y13 ...
Right or Wrong ...???
See Version 3 attached
Hope this will help


Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!