vlookup #n/a

I have a workbook that I am trying to return the total from one worksheet tab to another worksheet tab based on the insured name and plan. I have created a formula that returns the plan name based on the criteria so that the plan name matches on both sheets. I have also combined first and last...

I have successfully used the VLookup formulas for years. It is one of my go to formulas in Excel. I have a situation now that I can’t figure out. I am importing a list of codes from an outside source into my Excel workbook and trying to match them up with identical codes that already reside...

Hi All, I have a simple lookup formula; in cell N7 I have the below =IFNA(VLOOKUP(C7,'1SV'!A1:B731,2,FALSE,"") The user manually enters a value in C7 and N7 returns the correct value I now need to have a formula in C7 =SUM(A7+B7+D7) as an example and it still return the value like before in...

I'm trying to use the result of a formula as the array of a Vlookup formula In cell K3 I have the value of from a validation list from another workbook In cell M3 I have the formula =CONCATENATE($K3,"_Info") In cell K19 I have the value from a validation list from another workbook (same...

Hello, I'm familiar with VLOOKUPS and have used complex examples for many years, but everyone is human so maybe I'm missing something simple:confused: I'm using the VLOOKUP in a table and I'm new to using tables. I've checked the 13 possibilities here, even though some were not related to #NA...