• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Allow users to enter data 1 of 2 ways, autopopulate the column based on choice

K

Keith H

New Member
Hello all,

First post here. I'm trying to find a way to make my spreadsheet autopopulate one of 2 columns based on which one the user enters data into. Basically my workbook contains one table which holds product numbers and product names. Another table is used to create new orders. I'd like my users to be able to select either the name or the number, and have whichever one they don't select autopopulate. Make sense?

Thanks guys.

Keith
 
How about something like this:
=IF(ISNA(MATCH(EnteredValue,ProductNumbers,0)),INDEX(ProductNumbers,MATCH(EnteredValue,ProductNames,0)),INDEX(ProductNames,MATCH(EnteredValue,ProductNumbers,0)))

Whatever the user inputs, be it a product number or product name, the formula will return the correlating value.

PS. Not sure if you were implying it originally, but you can't have a formula and hard data in the same cell. One cell can be an input, or output, not both.
 
You must log in or register to reply here.
Back
Top