# Match a value against a date and enter the matched value

• May be ... you mean following

Code
``=IF(DAY(AW1)<10,"",IF(N9=4,BF1,""))``

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner

### Fluff1314 minutes ago

X post

and

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner

• 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 you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner

• =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

• Hello,

Corrected formula for cell N10

Code
``=IF(DAY(\$AW\$1)<10,"",IF(\$BF\$1=N9,\$BF\$1,""))``

Hope this will help

## Files

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner

Does it mean the last formula has solved your question ?

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner

• Hi

many thanx

This is working like a dream and solves my issues

I am really grateful for the solution

Regards

rajan

Thanks a lot for your Thanks ... AND for the Like

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner

• 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

## Files

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

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner

• 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

## Files

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner

• 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

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner

• Thanks for for Thanks

Hope you will soon become a well-known Expert in this ART ...

Take Care

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner

• 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 abovemany thanxrajan
• 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

## Files

If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner

## Participate now!

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