Using Vlookup in excel to populate records 1

[sap1958]

I have an excel workbook.
sheet1(cell E2) is blank with the field name Category.
sheet1(cell C2) is a text field named ProjID
sheet2(cell H2) is a poulated field name Category
sheet2(cell B2) is a populated field name ProjID
Objective, use vlookup to populate sheet1(cell E2) using a match between the sheet1(cellC2) ProjId and sheet2(cellB2)ProjId. Note in some cases the ProjId is either blnak or contains information other than a ProjId. How would I address this. I tried using the help feature to bring in vlookup but it died Here it is
=VLOOKUP(Sheet2!H2,C2,Sheet1!C2,FALSE)
DO I need to use iserror to deal with the ProjID

 

[SkipVought]

hi,

[tt]
=VLOOKUP(C2,Sheet2!$B$2:$H$9999,7,FALSE)
[/tt]

Note in some cases the ProjId is either blnak or contains information other than a ProjId.

What do you want to happen if no match is found?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}