One way

=INDEX(Sheet2!$C$2:$C$10,MATCH(A2&B2,Sheet2!$A$2:$ A$10&Sheet2!$B$2:$B$10,0))

entered with ctrl + shift & enter





--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"NWO" wrote in message
...
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 :)