Cant figure this one out.
I need the string to the column C from the column B where the code in the column A is the same.
On Sheet1 is what it looks like and on Sheet2 is what it should look like
If anyone can figure this one out i would be ever so thankful.
Last edited by PyhaWaim; 02-21-2014 at 10:43 AM.
Hi
Copy this array formula to c2 cell
=INDEX(Table1[Comment],MATCH(TRUE,IF(A2=Table1[PO],NOT(ISBLANK(Table1[Comment])),""),0))
Appreciate the help? CLICK *
Strange. If I copy this solution to my document i get #N/A. If I open your document everything works until I edit your formula - then the same thing happens.
Why is that?
That formula is an array formula.
Array formulas are entered differently than a regular formula. After you type in a regular formula you hit the ENTER key. With an array formula you must use a combination of keys. Those keys are the CTRL key, the SHIFT key and the ENTER key. That is, hold down both the CTRL key and the SHIFT key then hit the ENTER key.
When done properly Excel will enclose the formula in squiggly brackets { }. You can't just type these brackets in, you must use the key combo to produce them. Also, anytime you edit an array formula it *must* be re-entered as an array using the key combo.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Now it works perfectly. Thank you AZ_XL and Tony Valko.
You're welcome. We appreciate the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks