Hi
I have a spreadsheet looks like below
A B C D E
Date Register Shift In Charge Amount
1 04/05/12 Kitchen-1 1 Keyona $300
2 04/05/12 Kitchen-2 2 Shable $250
3 04/06/12 Kitchen-1 1 Mark -$100
4 04/06/12 Kitchen-1 2 Shable $500
5 04/06/12 Kitchen-1 3 Keyona $300
I'm using a userform and from a userform user will pick 3 criteria (Date - using a calendar named "cal1", Register - using a combo box named "cmb1"
and Shift 1,2, or 3 using a combo box named ("cmb2")
when user picks these 3 criteria I want a matching row and return value on column E on my Label - which I named lbl1)
I'm not sure if you can do this using excel worksheetfunction also please tell me where to put that code into
Bookmarks