copy cell if another cell range is equal to a cell.
Hello
I need a formula, which checks a range of cells, and if the value is equal to another cell, copies another cell value to this cell. For e.g.
I have a column(A) with a, b, c, d, in sheet1 and another column(A) in sheet2 with c, d, b, a. I want to copy values of C column of sheet1 to C column of sheet2, where the value of Column A in both sheets is a, doesn't matter which row.
thanks
Hi, welcome to the forum
I would suggest you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
Having said that, take a look at the VLOOKUP() function
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
See if this is what you had in mind:
http://contextures.com/xlFunctions02.html
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Hello FDibbins
Here is the worksheet with the 2 sheets. I want to fill the quote column with price column values if value of cell a2 in quote sheet matches the value of cell a2 in prices sheet.
thanks
Im not sure I follow your logic in your sample file? "be" from sheet1...cell A3...has a corresponding value on Prices of 9.6 (cell B4), not 4.35.
See if this is what you want...
=VLOOKUP(A2,prices!$A$2:$B$7,2,0)
put that in B2 and copy down
yes, that formula worked. thanks a lot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks