Vlookup return value in adjacent cell in ExcelFor example, you have two columns as shown in following screenshot. To vlookup the largest weight in column A and return the adjacent cell value of column B, please do as follows.1. Select a blank cell (here I select cell C3), copy and paste the formula =VLOOKUP(MAX(A2:A11), A2:B11, 2, FALSE) into the Formula Bar, and then press the Enter key. See screenshot:Then the adjacent cell value of the largest weight in column A is populated in the selected cell.Besides, you can vlookup and get the adjacent cell value based on a cell reference.For example, the referenced cell is C2 which locates value 365, for vlookup this value and return the value in adjacent cell. You just need to change the above formula to =VLOOKUP(C2, A2:B11, 2, FALSE), and then press the Enter key. See screenshot:This Index function also works: =INDEX($B$1:$B$7, SMALL(IF(ISNUMBER(SEARCH($C$2, $A$1:$A$7)), MATCH(ROW($A$1:$A$7), ROW($A$1:$A$7))), ROW(A1))) + Ctrl + Shift + Enter.Vlookup return value in the next cell in ExcelBesides returning value in an adjacent cell, you can vlookup and return value in the next cell of the adjacent cell in Excel. See screenshot:1.
Nov 23, 2016 You don’t. Excel is a spreadsheet, designed for manipulating tables of numbers. DNS is a system for translating the URL you type into (for example) a browser like.
Select a blank cell, copy and paste formula =INDEX(B2:B7,MATCH(680,A2:A7,0)+1) into the Formula Bar, and then press the Enter key. See screenshot:Then you can see the value in next cell is populated into the selected cell.Note: 680 in the formula is the value which I vlookup in this case, you can change it as you want.Easily vlookup return value in adjacent cell with Kutools for ExcelWith the Look for a value in list utility of Kutools for Excel, you can vlookup and return value in adjacent cell without formulas.: with more than 300 handy Excel add-ins,.1. Select a blank cell for locating the adjacent cell value.
Then click Kutools Formula Helper Look for a value in List. See screenshot:2.
In the Formula Helper dialog box, please do as follows:1). Click the button in the Tablearray box, and then select the range contains the vlookup value and the adjacent value you will return (in this case, we select range A2:C10).2). Click the button in the Lookvalue box, and then select the cell which you will vlookup and return its adjacent cell value (In this case, we select cell E2).3). In the Column box, click the button to select the column range which the adjacent cell locates in.4).
![Excel Excel](https://3.bp.blogspot.com/-jkwTxJv9ZuI/W4q6EWq-HkI/AAAAAAAAIeE/v3X07cj0fNwGWoDJ7tS6k6z62A3ig5PMACLcBGAs/s1600/Using%2BExcel%2Band%2BVBA%2Bto%2Bnslookup%2Band%2BPing%2BTest.png)
Click the OK button. See screenshot:Then you will get the adjacent cell value of cell A8.Tip.If you want to have a free trial of this utility, please go to first, and then go to apply the operation according above steps. Kutools for Excel - The Best Office Productivity Tool Increase Your Productivity by80%. Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails.
Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range. Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns.
How to Ping, NsLookup and Subnet Calculator in Excel. This short video shows how fast you can ping 50 hosts in Excel. NsLookup in Excel is fast.