-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
vlookup #n/a
-
E
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...- ebrandt
- Thread
- codes excel match #n/a vlookup vlookup #n/a
- Replies: 8
- Forum: Excel Questions
-
M
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...- matthewoaks
- Thread
- cell formula lookup vlookup vlookup #n/a
- Replies: 11
- Forum: Excel Questions
-
S
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...- scottkalas
- Thread
- cell formula result vlookup #n/a workbook
- Replies: 3
- Forum: Excel Questions
-
O
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...- ohnow
- Thread
- data formula sheet vlookup vlookup #n/a
- Replies: 1
- Forum: Excel Questions
