Good Day Everyone. I'm stuck on the below situation and your help will be much appreciated.

he situation is, I need to return the "figures" from WORKSHEET 2,  To the WORKSHEET 3 considering the "Figures" from WORKSHEET 1.

 The Spreadsheet 3 is the results from the other 2.

On spreadsheet 1 You read the Number of the Waiter and his name. Eg.(401-LILIK, 402-BRATA, 403,IRWAN) which actually "served" the respective Room/Cabin. 

As you see, on DAY 1, IRWAN served Room 105 , LILIK Rooms 107&108, BRATA Room 110..... and on and on.....

On Spreadsheet 2 You See the "Rating" the Guest returned, between 0 & 4....

So, with this information on Spreadsheet 1 & 2, I need it to return to the respective Waiter on Spreadsheet 3 accordingly. 

I hope it's clear. Thank you so very much in advance for whoever help on that one.

• Edited by Gutoazuk 8 hours 58 minutes ago

• Worksheet 1:

Room	DAY1	STW	DAY2	STW	DAY3	STW	DAY4	STW	DAY5
105	403	IRWAN					401	LILIK
106									403
107	401	LILIK			401	LILIK			401
108	401	LILIK
109									402
110	402	BRATA

 

• WorkSheet 2:

ROOM	105	106	107	108	109	110
RATING	4		4	3	4	4

• Work Sheet 3:

402	BRATA
Rate
Excellent	4	109	110
Good	3
Fair	2
Poor	1
No rated	0
401	LILIK
Rate
Excellent	4	107
Good	3	108
Fair	2
Poor	1
No rated	0
403	IRWAN
Rate
Excellent	4	105
Good	3
Fair	2
Poor	1
No rated	0

Excel 2010 with free PowerPivot and Power Query Add-Ins.
Compatible with Office 2013 Pro Plus.
No formulas, no VBA macro.
http://www.mediafire.com/view/kp8tch9ww64yj41/07_05_15.xlsx