Hi,

I'm Sneha and I'd be happy to help you out with your question.

It sounds like you are trying to use VLOOKUP to match names in one list with corresponding numerical values in another list. If you are getting #N/A errors, it could be because the names in the two lists are not an exact match. VLOOKUP only returns a result if the lookup value is exactly equal to the value in the first column of the lookup range.

There are a few things you can try to troubleshoot this issue. First, you can try using the TRIM function to remove any leading or trailing spaces from the names in both lists. This can help ensure that the names are an exact match. You can use the formula =TRIM(cell) to remove extra spaces from a cell.

Another thing you can try is using the IFERROR function to handle the #N/A errors. IFERROR will return a specified value if a formula returns an error, so you can use it to return a blank or a default value instead of the #N/A error. For example, you can use the formula =IFERROR(VLOOKUP(B2:B1201,F2:G1133,2,FALSE),"") to return a blank value instead of the #N/A error.

You can also try using the MATCH function in combination with VLOOKUP to find approximate matches. MATCH can be used to find the position of a value in a range, and then VLOOKUP can be used to return the corresponding value in a different column. For example, you can use the formula =VLOOKUP(MATCH(B2:B1201,F2:F1133,0),F2:G1133,2,FALSE) to find the approximate position of the lookup value in the first column of the lookup range, and then use VLOOKUP to return the corresponding value in the second column.

If you have any other questions or need assistance with anything, please don't hesitate to let me know. I'm here to help to the best of my ability.

Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.

Best Regards, Sneha