Need help with VLOOKUP formula.

[irrefutable14]

I want it to insert the name from column "C' sheet- 'Assign ASUS HERE' and place the name in "B" of the sheet of the code
When I changed the formula it returned "N/A". Any ideas how to fix it? I'm new to excel.

=IF(B3="","",VLOOKUP(B3,'Assign ASUS HERE'!$A$2:$B$961,2,FALSE))

 

[Momentman]

Are you certain the name you seek is there. Check that there are no spaces before the name like " NAME" or "NAME " or " NAME " vs "NAME", these are all treated differently by Excel

 

[irrefutable14]

There are no spaces. I want it the vlookup to retrieve what's in column C of the 'assign asus here sheet' instead of what its doing now; retrieving whats in column 'b'

 

[Momentman]

There are no spaces. I want it the vlookup to retrieve what's in column C of the 'assign asus here sheet' instead of what its doing now; retrieving whats in column 'b'

Then you need

=IF(B3="","",VLOOKUP(B3,'Assign ASUS HERE'!$A$2:$C$961,3,FALSE))

 

[irrefutable14]

Thanks a lot! It worked perfectly!