|Based on your description, this should work:|
=VLOOKUP(F11, SHEET2!$B$6:$B$240, 2, 0)
If you are getting #N/A it is because VLOOKUP is not finding a matching value in SHEET2!$B$6:$B$240.
Maybe you've got an extra space or something like that in one of the lists.
Try this test:
Find a matching value for SHEET1!F11 in SHEET2 Column B and note what cell it's in, e.g. SHEET2!B23.
Enter this in any cell =SHEET1!F11 = SHEET2!B23
If there is an exact match, that will return TRUE and VLOOKUP should work. If the values are different in any way, it will return FALSE and VLOOKUP will return #N/A.
If they don't match, you'll have to figure out why.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.