# vlookup #n/a

1. ### Vlookup problem

Hi gents I am trying to lookup the order number in one spreadsheet (Input Sheet, column B) matching it with the same number on another spreadsheet (CustomerService, column B) and then return the date it was finished on the CustomerService sheet, column J. But it keeps coming up with #N/A and if...
2. ### VLOOKUP Problem

I have a cell using the formula =(DATEa-DATEb)/365 ( actual formula is =(C11-E7*1/365*1 where cells C11 and E7 are dates) to give me the number of years an employee has worked at the company. The cell is formatted to a number with zero decimal places so that it will round up to whole numbers...
3. ### Vlookup with indirect returning 0, when value is present

Hey everyone, Looking for some help again. I have a formula..... =IFERROR(IF(\$G\$8="Primary",VLOOKUP(I\$8,INDIRECT("PrimaryDailyRange"),2,0),IF(\$G\$8="Secondary",VLOOKUP(I\$8,INDIRECT("SecondaryDailyRange"),2,0))),0), that works exactly how I need it to in one worksheet. The next worksheet is...
4. ### VLOOKUP and extract #N/A rows

Hello experts! I hope my question is as easy for you as it seems to me: I've got two tables I'm comparing. Both tables have the index, StudentID, a 10-digit number. I'm using vlookup to compare the tables to find which students are missing from either table (Table A compared to Table B, and...
5. ### Return value if there is an #N/A error

Okay so I have a list of numbers that will be pasted next to an already placed VLOOKUP function, this VLOOKUP will lookup the numbers pasted in another list. This means the VLOOKUP returns a list of all the numbers that already exist in the 'lookup list' and then #N/A if a new number is there. I...
6. ### VLOOKUP doesn't return values when cell is text and has duplicates

Hi I have two worksheets, Unique Donors & Donations. I've assigned a unique alphanumeric code to each Donor and need to return that value against their Donations. VLOOKUP returns the first 3 values bu when it comes to a repeated value it stops. Amy help here much appreciated Unique Donors...
7. ### VLOOKUP all are RETURNING N/A except three cells

See below, the first two columns - I called it table 3 I created a vlookup where 98% returned with a #N/A except for three cells? Can you please help me understand why this is happening? Copy and paste into your excel - the format is the same acrosss the board? Also why can't I upload an...
8. ### VLOOKUP Error #N/A Array Containing Formulas

From Cell D37 I entered the formula: =IF(OR(B37="",L36=""),"",IF(L36="SD",VLOOKUP(B37,H9:L33,4,0),IF(L36="MM",VLOOKUP(B37,H9:L33,5,0)))) The typed in value of D37 is 13. H9:H33 have formulas that produce numeric values. The formula-generated value in H15 is also 13. This formula returns #N/A...
9. ### vlookup not working

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...
10. ### Why won’t my VLookup formula work?

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...
11. ### Vlookup value is returning N/A when referencing a cell with sum formula in

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...
12. ### Vlookup result of a formula for Table Name

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...
13. ### VLOOKUP Only Returning Some Values otherwise #N/A but Index/Match Works

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...

### This Week's Hot Topics

• Copy entire row if CountA <>0 to another sheet
[B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
• Select last used Row in Table
I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
• excel workbook: do not allow certain file name
Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
• fixing problem autofilter
hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
• “Weight”
Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
• How to capitalize everything before a certain character?
In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...