Match the value from a cell with data from a table

[khanaran]

Greetings

I am learning numerology and the lotto with excel spreadsheets.

I am able to calculate a value in a single digit of the date.

My question is how may I break down the date into single digits which fills in cells two for date two for a month and four for the year.

The second part of my request is how to copy a row of data if it matches a value from the calculations of the date

If I reduce the date for example 21 August 2018 (21-8-2018) value will be 4. This 4 I would like it to match the 4 in a table and copy the corresponding values back to the sheeet

I thank you all for all help and advice received

[FDibbins]

Hi, hoe gaan dit in Joeies?

PE old boy here from Orkney and Klerksdorp, now living in USA

So, 1st you want the date broken out into it's individual numbers, right? What if the day is less than 10?

[FDibbins]

Assuming I am correct...
C5=IF(DAY($E$2)>9,--LEFT(DAY($E$2),1),0)
D4=--RIGHT(DAY($E$2),1)
E4=IF(MONTH($E$2)>9,--LEFT(MONTH($E$2),1),0)
F4=--RIGHT(MONTH($E$2),1)
H4=--LEFT(YEAR($E$2),1)
I4=--MID(YEAR($E$2),3,1)
J4=--RIGHT(YEAR($E$2),1)

[khanaran]

Greetings

Goed dankie

I live in Lenasia Johannesburg

Thanx for the help, however, the year part one line is missing all ok and its working greatly

the first part of the request is working just needs a slight tweak

I figured out the missing line

G4=--LEFT(YEAR($E$2),1)
H4=--MID(YEAR($E$2),2,1)
I4=--MID(YEAR($E$2),3,1)
J4=--RIGHT(YEAR($E$2),1)

Hope I am correct here

regards

Raj

PS nice to chat to a fellow South African

I will greatly appreciate it very much if you can help and solve the second part of my request

[FDibbins]

oops I skipped G...
G4=--LEFT(YEAR($E$2),1)

[khanaran]

Hi

Thanx a span for the help and at the same I am learning even at the age of 66

Regards

raj

[FDibbins]

Never too old to learn new stuff (Im 60)