store daily info in a database

[Lux Aeterna]

Hello everyone.

I have created an excel workbook where I write down our daily patients. I would like those daily info to be stored in a database, from which I'll be able to draw info next time those patients visit again.

ID	NAME	Father's name	Phone	RN
1	Mike	Aaa	1001	12345
2	John	Bbb	2002	23456
3	Maria	Ccc	3003	34567
4	Cathrine	Ddd	4004	45678

<tbody>
</tbody>

I would like every day to store specific info: Date (not included in that sheet right now, but I will add it), ID, Name, Father's name, RN, Phone) and to be able to search for them in the created database using their RN. So that, when I search in the database RN "12345", it will give me all Mike's info.

Moreover, I would like to be able to draw info from that database, so when a patient visits again I will submit their RN and fill out all fields (Name, Father's name, Phone) automatically.

Hope my message makes sense...

Thanks a ton

 

[oldbrewer]

ID

date

NAME

Father's name

Phone

RN

1

01/10/2018

Mike

Aaa

1001

12345

2

02/10/2018

John

Bbb

2002

23456

3

03/10/2018

Maria

Ccc

3003

34567

4

04/10/2018

Cathrine

Ddd

4004

45678

at the end of each day copy info to database NOTE RN IS NOW FIRST COLUMN

cells K13 to cells P1000 is your database to allow for expansion

enter patient RN into cell A20

RN

ID

date

NAME

Father's name

Phone

12345

1

01/10/2018

Mike

Aaa

1001

23456

2

02/10/2018

John

Bbb

2002

34567

3

03/10/2018

Maria

Ccc

3003

45678

4

04/10/2018

Cathrine

Ddd

4004

ID

date

NAME

Father's name

Phone

34567

3

03/10/2018

Maria

Ccc

3003

row 20

the formula for id is

=OFFSET($K$13, MATCH($A$20,$K$14:$K$1000,0),1)

the last 1 is 2,3,4,5 for date,name,fathers name,phone

<colgroup><col><col><col><col span="9"><col><col span="5"></colgroup><tbody>
</tbody>

 

[Lux Aeterna]

Thank you very much for your answer. I just found the time to check the formula. Unfortunately I get #N/A message.

Please check

https://imgur.com/a/Vo8LpKF (or https://imgur.com/k6zBrnS if the other one doesn't work) for a screenshot, is there anything I've done wrong?

PS. ";" is the equivalent for ","

 

[oldbrewer]

put a few rows up with your formula - mine works and I told you the cell locations.......