Search and retrieve

[mmn1000]

hi,
I have 3 sheets in this attached file where I record information in the data sheet and it is saved in the Save_Data sheet.

In the Admin sheet, how can I write a formula that by entering the date and user name, the registered information from the Save_Data sheet will be called and placed in its place marked with yellow color.
Now, it doesn't matter with VBA or formula writing, this is possible

M

MediaFire is a simple to use free service that lets you put all your photos, documents, music, and video in a single place so you can access them anywhere and share them everywhere.

www.mediafire.com

 

[mmn1000]

Dear friends and professors, was there no one to help me?

 

[mmn1000]

hi,
I have 3 sheets in this attached file where I record information in the data sheet and it is saved in the Save_Data sheet.

In the Admin sheet, how can I write a formula that by entering the date and user name, the registered information from the Save_Data sheet will be called and placed in its place marked with yellow color.
Now, it doesn't matter with VBA or formula writing, this is possible

M

MediaFire is a simple to use free service that lets you put all your photos, documents, music, and video in a single place so you can access them anywhere and share them everywhere.

www.mediafire.com

Hello
If this question of mine has no solution, please tell me so that I can close this question and look for another way
Thank you for your cooperation, my dear friends

 

[mmn1000]

I used the following formula to return the data

=VLOOKUP(date;INDIRECT("Save_Data"&"!c2:cg2");2;0)

=VLOOKUP(date;INDIRECT("Save_Data"&"!c2:cg2");3;0)

.....
In this formula, there is only one date condition, I want the username to be in the condition
Information can be retrieved under two conditions

MMN

MediaFire is a simple to use free service that lets you put all your photos, documents, music, and video in a single place so you can access them anywhere and share them everywhere.

www.mediafire.com

 

[Alex Blakenburg]

It is really unclear on what you are trying to achieve. Your example formulas use VLookup but the range is 1 row.
I don't follow what indirect is doing for you in the formula.

Show us a picture including row and column indicators of which values you are using to do the lookup and a picture including row and column of what you want the formula to find.

PS: your spreadsheet is full of merged cells which is something most experienced excel users avoid like the plague. It will always end up causing you problems.