LinkBack URL
About LinkBacks
i have Criteria in Col A ,i want my result in col D reference by match in col A
i have Criteria in Col A ,i want my result in col D reference by match in col A
This should do the trick.
Please Login or Register to view this content.
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
JapanDave : formula still error
Kind of a low tech solution that involves helper columns, which may be hidden fro aesthetic purposes (thankfully excel has over 16,000 columns).
The formula that populates the helper columns is:The formula that populates column D is:Formula:
Please Login or Register to view this content.Let me know if you have any questions.Formula:Please Login or Register to view this content.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
If you are open to a VBA solution this User Defined Function does well.
http://www.excelforum.com/tips-and-t...ml#post3096647
Then the formula array-entered in D5 and filled down would beIf you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.Formula:Please Login or Register to view this content.
Dave
With a helper column this can be done very easily.
Say Helper column is D and Result column is E. Then
On D5 write this array formula :
On E5 write this array formula :Please Login or Register to view this content.
Press Ctrl+Shift+Enter to confirm array formula.Please Login or Register to view this content.
Now copy them down and hide the helper column. That's it.
See the attachment.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks