Hello.

I have two worksheets.

Worksheet#1 has a unique ID field named ID which is populated, and some
other fields, including a field named Formtype that is populated, a field
named Hours that is blank.

Worksheet#2 has a matching ID field and Formtype field, both populated, in
addition to an hours field that is also populated with hours data.

What I am trying to do is use the VLOOKUP function to match the ID AND the
Formtype fields, and using these fields, find the corresponding hours value
on worksheet #2 and use this value to populate the Hours value on Worksheet#1.

Any ideas would be appreciated.

Thnak you.

Mark :)