Formula to match data

[RattlingCarp3048]

I am trying to match data from one sheet to the next. I tried a vlookup but keep getting the #spill! error. Maybe you guys can help? Basically what i am trying to do is.... we have multiple employees with an assigned department but they cross train in other departments. I need to line their hours up in the appropriate fields. On Sheet #1 I need columns F, G, and H to search for the name in A + Packing, Produce, or register and return the value. This is a small example, there are many many more names so limiting the search to the name would not be dynamic enough. I would prefer a formula if possible rather that VBA.

In this case F2 should search for Matt + Packing and return 4.
F3 should search for John + Packing and return 17 etc...

Then G3 should search for John + Produce and return 1.

Then H4 should search for Annie + Register and return 15.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[jtakw]

You're welcome, thanks for the feedback, hopefully it all works out.