vlookup #na

Hi guys.. I have the following 3 columns in my excel sheet. The dates in column A (DateTime) are in the same format as column N(DateTime2). <tbody> DateTime (column A) DateTime2 (column N) Match VLOOKUP <colgroup><col></colgroup><tbody> 1/1/16 0:00 </tbody> 1/1/16 0:00 1 42370...

hi, i have been trying to solve my vlookup formula however i couldnt find what wrong with it. basically what im trying to do is that when the user input the timing, there will be animal output in another cell. the reason is that I will like to do dependent drop downlist. here is the array...

Hi folks, I've got a spreadsheet with column 'A' having either N/A, Low, Medium or High. In column 'B' I've got the following formula =lookup("range",{"High","Medium","Low","N/A"},{"10","5","1","0"}) I want column B to provide one of the following responses depending on what is in the cell on...

Got the easiest spreadsheet and really frustrated to why my Lookup function won't work or Index/Match combination. Key column are A and K - want to find minimum value in column K and the corresponding value in column A - Table array from A9 to K10000 - Make separate cell for Minimum value...

Greetings, Been working this problem for hours, one worksheet referencing another with vlookup. Column A in both sheets contain times in 15 minute increments ws1: A3:A48 = time of day in 15 minute increments B3:B48 = various activities in text ws2: A3 is a dropdown with a specific time (6:00...

I have a vlookup as part of my macro where I through all the rows in the sheet and do a vlookup against another sheet in another workbook. I was able to successfully get the vlookup to work through this method in VBA: Report1.Range("D1:D" & LastRow).Formula = "=VLOOKUP(A1, " & TableRange & "...

I use an odbc connection to pull SQL tables in excel. I am having difficulty doing VLOOKUPS on these tables with my own created excel data. I can change the format but thats only a temporary solution. Once i refresh that table I get N/A's. Any insight?

Hi, I have set up a vlookup, which pulls in a row of data from a unique user from a table of results. At the moment my user chooses from a list of exams to display the certain data related to a unique user: =VLOOKUP($B9,results!$A$3:$K$70,3,FALSE) <tbody> Choose Exam from List to Display...

I'm having a difficult time trying to figure this out. I've used vlookups before but can't seem to figure this out or what I'm doing wrong. I have data I use each month and often the source data may not have the city or the zip. I have used a vlookup to find the city name and tag it in a new...

I am really not good at Excel and am battling to finish my formula. I apologise in advance if this has been answered before but I can't fidn the right formula. The first part of my formula works really well. It basically looksup a Trade Discount percentage (from a named table) and delivers...

i'm trying to pull a sum of each column from all 13 sheets onto a summary sheet using a combination of sum and vlookup. f(x): =SUM(VLOOKUP($A3,'Jan 16'!$A:B,2,0))+(VLOOKUP($A3,'Feb 16'!$A:B,2,0))+(VLOOKUP($A3,'Mar 16'!$A:B,2,0))+(VLOOKUP($A3,'Apr 16'!$A:B,2,0))+(VLOOKUP($A3,'May...

Hi! I'am trying put a value in a selected cell using if and vlookup. Here is the formula =IF($N13="","",IF(VLOOKUP($N13,Directory!$F:$F,1,0)=$N13,"G",IF(VLOOKUP($N13,Directory!$G:$G,1,0)=$N13,"S","")) It returns "G" if the value returned from vlookup from column F of directory is equal to...

Hi guys, I'm trying to do a vlookup that looks at different letter ratings (AAA,+AA,AA,AA-,A+,A,A-,etc.) and give that letter rating a numeric value from 0 to 100 that is in an array in another worksheet. But for some reason, my vlookup doesnt seem to recognize the letter rating either in the...

Hi all, I am trying to remove/leave blank the #N/A result of a formula containing two nested IF statements and a Vlookup. The current formula is: =IF(A2<>"",IF(A2<>"JOHNSMITH",VLOOKUP(A2,'Sheet1'!$A$2:$AH$143152,34,FALSE),""),"") I've tried placing an IFERROR before the entire formula as...

Hi, I have to compare 2 sheets for work, they are as follows: Sheet 1: Column A: Preferred Site Column B: Student ID Number Column C: Surname Column D: Forename Sheet 2: Column A: Allocated Site Column B: Student ID Number Column C: Surname Column D: Forename I need to find out how many...

Hi All, I have a table similar to the one below: <tbody> Product 1 Product 2 Product 3 Product 4 Product 5 Total Cost Shoes Chair Hat Belt $100.00 </tbody> What I am trying to achieve is getting the SUM total of any products selected under any of the product headings, where the...

I have an old sheet that we use to compare values from multiple sites for each month of the year. I am sure there are ways of simplifying the formulas but I am just looking for a way to get it to return a "0" or blank value if the values are not found for a given site for the month selected...

Hello, I need help with vlookup please, can't seem to get it working. Probably i am missing something here. I'm trying to extract info from column A in to column F by comparing 'B' and 'E'. Formula used in column F: =VLOOKUP(E66,A:B,1,FALSE) <tbody> FN1 FN2 FN3 FN1 DES00007 CZC20601SX...

I have a file with 2 sheets: Sheet1: image URL | product name http://www.auchandrive.fr/drive/static-media/front/pictures/product/zoom/903741.jpg | aaa...

I'm trying to match names of companies in one worksheet with another but LEN returns different values. I use trim and still different lengths. What can I use so they match? My goal is to use vlookup or another function to see company rankings on other worksheets. Can anyone provide advisement?