Could i have some help please Double VLOOKUP.

[justtylersmith]

Firstly , I am a very basic excel user but with some advanced understanding! Basically i'm trying to build a double Vlookup (I think) a method on where i enter a persons name or ID number and a date. and it will retrieve if they are scheduled busy or free. Also i would like it that if i delete a name or ADD a name it will automatically update. Could somebody please teach me step by step or just build a quick file for me to download i would be sooooooo grateful!!!!! see photos and excel file below for details.

database Vlookup1.jpgdatabase Vlookup2.jpg

schedule.xlsx

[:) Sixthsense :)]

Please attach a sample workbook with enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).

[justtylersmith]

i Have attached the file. in my first post but here it is again. basically the lookup system is going to be used to see if the person is free or busy on the searched date. For example i put in the users ID or name i enter date i would like to see if they are busy and it gives me a status saying busy or free.

schedule.xlsx

[:) Sixthsense :)]

In B2 Cell

Please Login or Register  to view this content.

In B8 Cell

Please Login or Register  to view this content.

[justtylersmith]

sorry to be so dumb but i have just tried your solution and its obvious im doing something wrong, do you mind attaching the revised spreadsheet please?
You have been so helpful thank you so much!

[:) Sixthsense :)]

Oops... Sorry for the confusion...

Input the 1st formula in B4 cell and second formula on B8 cell andyou have to input the ID manually in B2 cell.

[justtylersmith]

i cannot thank you enough! should be more people like you in the world

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback