Hi,
Quite difficult to explain this one...
I am looking for an 'if' function formula that says if the value in COLUMN C is equal to a value in COLUMN A, then put the value of COLUMN B which is in the same ROW as the matched value in column A in column E. Below is the table and I have attached the excel too. Would greatly appreciate any help!
A B C E D
# Price # (Formula should bring up)
1 10 1 10
2 12 2 12
3 14 3 14
4 16 1 10
5 18 1 10
6 20 7 22
7 22 6 20
Thanks,
Leopold2000
the data you have supplied does not match what you are requesting? in A you have dates, in C you have numbers (1 to 7) they will never match?
the if() function works as follows...
=if(criteria-to-be-met, what-to-do-if-it-is-met, what-to-do-if-it-is-not-met)
edit: i think this is what you wanted?
=INDEX($A$1:$G$16,MATCH($J3,$C$1:$C$16,0),MATCH(I$1,$A$1:$G$1,0))
Last edited by FDibbins; 12-05-2012 at 04:40 PM.
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
Try this formula in I2 copied down
=INDEX(B$2:B$100,MATCH(J2,C$2:C$100,0))
Audere est facere
Sorry the attached is correct.
Hi couldn't get your formulas to work unfortunately! Any chance you could look at the excel I just attached (which is definetly correct!) and help me out!?
based on your latest sample, try this, copied down...
=VLOOKUP(C2,$A$2:$B$8,2,FALSE)
Genius. Thanks.
Leopold,
Try this:
in E2, dragged down as far as required.
Please Login or Register to view this content.
Brendan.
__________________________________________________________________________________________________
Things to consider:
1) You can thank any poster by clicking the * at the left of a helpful post.
2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks