LinkBack URL
About LinkBacks
Shall seek the numbers in column A, and if the number is 2 in column D (E) shall result in value listed in Column I be the answer.
Is there a formula for this?141210 Excel formel.xlsx
Formulas with cells that are merged
Shall seek the numbers in column A, and if the number is 2 in column D (E) shall result in value listed in Column I be the answer.
Is there a formula for this?141210 Excel formel.xlsx
1. don't merge cells in excel!
2. Where you want that as output?
I have received spreadsheet like that. I have a separate worksheet where it is listed a lot of numbers. These numbers must I find in column A of this worksheet. I need the number printed in column I, if the number in column D-E is 2.
Oh yes, agree, never merge cells....
Hi, welcome to the forum
When I have to do something like this, I often add a helper column to pull in the contents of merged cells into individua cells.
Put this in J2 and copy down...
=IF(A2="",J1,A2)
Once you have that, you can use a regular INDEX/MATCH to bring back what you want...
=INDEX($I$2:$I$18,MATCH(21363429&" "&2,INDEX($J$2:$J$18&" "&D2:$D$18,0),0))
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
Thank you.
Understood IF, but the INDEX/MATCH surpasses my understanding.
But I helped largely, and has now managed to solve the task, with little manual work.
Thanks again:-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks