Hello,
I am currently trying to figure out a formula for when i select from the drop-down boxes it returns a value that i have placed next to it on a separate sheet. I have attached an example of what i am trying to accomplish thanks for the help ahead of time.
Last edited by jleal; 06-25-2014 at 04:00 PM.
Try this. Entered a helper column in your reference sheet.
HTH.
Pete
Yes i can make this work.
Thank you!
Array Formula (committed with Ctrl-Shift-Enter) in cell F6 (and copied down)
committed with Ctrl-Shift-Enter rather than just Enter.Formula:
Please Login or Register to view this content.
It will display in the cell as:
Formula:Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks