Help with a Vlookup criteria

I have a Vlookup formula that I want to recognize a column from one sheet and match it to a column from another sheet and output the next row according to the name.

Example Sheet1:

HTML Code: 

Example sheet2:

HTML Code: 

I want to pull the first scores from the second sheet into the first sheet based on names

Please Login or Register  to view this content.

I used this and I'm getting zerosCopy of Sanitation Rport for SY12 as of 10-11-12 filter on Second Score.xls

Hi missmea,

Try using below formula:-

Formula:

Please Login or Register  to view this content.

See attached:- Copy of Sanitation Rport for SY12 as of 10-11-12 filter on Second Score.xls

Regards,
DILIPandey

<click on below 'star' if this helps>

do you mean
=VLOOKUP(E2,'By RESA'!$F$2:$G$1000,2,FALSE)
or in excel 2007 or later
=iferror(VLOOKUP(E2,'By RESA'!$F$2:$G$1000,2,FALSE),"")