VLOOKUP giving #N/A and I have no idea why
Why doesn't this work? I tried checking for whitespace, made sure length was the same, etc. Driving me nuts! I just want Alabama! The error given is "Value not available".
Solution
The usual solution is to apply =MATCH to find the row number in the array:
=MATCH(D1,B:B,0)
will search for the value in D1 in ColumnB (the last 0 means exactly) and hopefully return 2 (the second row in the chosen array - ie the whole of ColumnB). This can then be fed into:
=INDEX(A:A,MATCH(D1,B:B,0))
where it becomes the second row of ColumnA, ie Alabama
Details here =MATCH =INDEX and also http://www.excelhero.com/blog/2011/03/the-imposing-index.html
- Need help to extract this XML node - Excel connection strings in Python
- Shift the range up after clear contents
- Enter Cell Formula using VBA
- Content is out of order when using Excel VBA to create a Word document
- Trouble with Vlookup on power queries?
- excel - hyperlink to sheet based on cell value
- Accessing a Variant/Object/JScriptTypeInfo property in VBA
- Move data to another table based on array value
- Partial exists in dictionary
- Name on Envelope
- Sorting data algorithm 900000 rows of data
- Expression.Error: We cannot apply operator & to types Number and Number
- Importing/scraping an website into excel
- Scraping Morningstar web page
- How do I get my For Next loop to actually loop
- Figuring out the number corresponding to a letter of the alphabet?
- how to select worksheet name from cell
- Npoi Round Formula
- How to get the sheet name from Application.Caller?
- How to declare variable by using for-next loop
- Apache POI Excel - how to configure columns to be expanded?
- How To Copy/Cut Row of Data Based on TRUE/FALSE Condition
- Workbook "Calculation Options" stays in Manual no matter the operation (open, save, close) being performed unless approved user hits Calculate
- Excel automate dynamic number of row generation from another set of data
- How to put sum of dataframe column in certain cell of excel sheet?
- Remove all special characters except space
- Excel is stripping leading 0's from CSV files
- Excel Button for a par sheet
- Remove border between Excel and PPT for a copy and paste VBA
- List of data.frame's to individual excel worksheets - R