You are here: HomeExcelTutorials

# Match value in one column and return value in same row in next col

## Match value in one column and return value in same row in next col

Price: FREE

I have a a set of values in A1 through A100. I need to look up each value and find a match in another set of values located in C1 through C200. If a match is found then I need the formula located in column B to return the value in the same row but the next column over (D).
Example:
A B C D
The formula located in B3 should find that the value of 125 (located in A3) matches the value in C2 and returns 10031 which is the value located in the next column over in the same row.

Visit publisher's web-site: Match value in one column and return value in same row in next col

Category and Tags: ExcelTutorials :

## Related Tutorials

### match 2 columns and return value of another

Free: Yes
Tags: Excel › Functions

I would like to match col A with Col Q, for instance if there is 100 in Col A and Q, then I would like to return the value in Col I which represents the value for col A 100 in the same row. I hope this is clear. It would save me a lot of manual input.

### match values in two column and return value in

Free: Yes
Tags: Excel ›

I want to look in two columns. I want to look in the first column for a cell that matches the data in another cell. And with that value, I want to find a blank value in the second column. Once it finds the row with this value, I want to return the value in column G of this row. Example:
Col A Col B Col G
TBD 1 200
TBD 1 X (This is where I want to look for the
value TBD 1
in column A and blank in Col B, so
it returns
the value 200 from column G)
TBD 2 100
TBD 2 X
Can you help with a formula?

### lookup/match mult values

Free: Yes
Tags: Excel › Functions

SHEET 1: (lookup Values)
COL A - House #
COL B - Group Name
SHEET 2: (lookup Vectors & Array)
COL C - House #
COL D - Group Name
COL E - Amount (RETURN VALUE)
I want to use a lookup formula of some sort to match the row from Sheet 1 using information from Columns A&B.
Then match it with the rows in Sheet 2 that have the EXACT matching information in Columns C&D, and then return the value from Column E.
For example,
Sheet 1:
COL A COL B
1486 Yellow2
Sheet 2:
COL C COL D COL E
1486 Blue1 97
1486 Yellow2 26
So I would like the return value to be 26 (not 97)

### Vlookup for different columns in worksheet

Free: Yes
Tags: Excel › Functions

I have numbers in col A , which I would like to match in col E and if there is a match I want it to return that exact number in col M. Would it then be possible to return the values of that row Col F,G,H,I,J,K,L by copy across

### If, Lookup, Match or a combination of all

Free: Yes
Tags: Excel › Functions

I have 1 excel spreadsheet with several worksheets. What I need to do is to take the value from 1 cell in one sheet look at a list of values on a second sheet and return the value but only if there is an exact match else I need it to return a 0. At the moment with Lookup it is returning a value that is the closest match.
Sheet 1
Column A Column B Column C Column D Column J
subtotal name title Code Value of Col B
from sheet 2
Sheet 2
Column A Column B
Code Value
I need it to look the value from column D in Sheet 1 and match it to the Code in Column A on sheet 2 and return the value of Column B to Col J in sheet 1 else return a 0

## Related Applications & Scripts

### Space Match Memory game - Advanced

Free: No
Tags: Flash › Excel Games

In this space style memory game you have to flip tiles over to match two icons. Flipping over all the tiles ends the game.
This game features a timer and the game remembers your time for the session you are in. The game also has sound.
This is the advanced version of this file. It has the following features:
- PHP compatible saving to text file (.txt)
- ASP compatible saving to tex tfile
- Level select
Easy, Medium and Hard
- Individual scores for each level
- Sorts scores by best time

### Bookmark Popup

Free: No

Do you want your visitors to return to your site and share your message with friends, family, and coworkers? The easiest way to keep visitors coming back is to encourage them to bookmark your site. By bookmarking a website visitors are reminding themselves that they want to return to your site.
Not only will this increase your sites basic but it also increases your sites popularity. Many web site owners do not realize that a sites true popularity is based upon its repeat visitors. The number of repeat visitors shows that your site is so appealing that it not only attracts many unique visitors, but it also encourages these visitors to return time and time again. If you are someone that is selling a product the majority of sales and conversions are made because of return visitors. It often takes many visitors more than one visit to a web site to decide whether or not they are going to make a purchase. I myself will often visit an online store several times before committing myself to an actual purchase.

### DataTable or Data Grid

Display of data through DataTable facilitates data management: - The rows can be ordered by clicking on the header of the column that you wish to order by. - You can set your own table size: set width, height, or both. If you set the size, scrolling bars will be shown when the amount of data requires it. - For tables with a high number of rows: Rows can be separated in pages, thus allowing to move between pages; you can also change the amount of rows per page; - Each row in the table will show a column defined by user - either Delete the row, or Edit it. Packaged into a Dreamweaver extension. No hand coding needed.

Free: Yes
Tags: JavaScript › Excel Drop Down Menus

Drop Down Tabs is a horizontal CSS tabs menu that supports a second level drop down menu for each of its tabs. The entire interface is rendered in plain HTML, making the script very easy to customize, plus all of its contents are search engine friendly. You can optionally set which tab should be selected by default when the page loads (ie: 1st tab, 2nd tab etc), or have the script automatically select a tab when the page loads based on a match between the current page's URL and one of the menu tabs'. If there is a match, that tab is selected.
Drop Down Tabs comes with 5 sleek examples to let you quickly pick your favourite to use on your site. Customize each example's CSS to modify the look as desired. We got you covered alright!

### SamMySql Database Class

Free: Yes
Tags: PHP › Excel Classes MySQL

This class wraps common MySQL database table SQL queries. It can:
- Perform SELECT queries and retrieve a single value, a single row into an array and all rows into a multidimensional array.
- Insert or update rows from a list of fields and values
- Delete table rows that satisfy a condition
- Count records in a given table
- Check if a table record exists with a given field value
- Perform a database search
- Return a certain number of rows of result from database, et