Hello - Thanks in advance for your help.
I have a spreadsheet with text and numerical columns and need a formula to auto-populate a related cell depending on the value of another cell.
For example, if D1 value is "Auto" I want E1 to auto-populate with "Operating Expense". There are several different values in column D which I'd tie to different values for column E. Seems like a rule that I could set up but I'm not sure where to do that.
Attached is a sample sheet.
Thank you!
Sarah
Very normal place to use a lookup table.
In E1:
Where K1:K10 are the input values ("Auto" etc) and then L1:L10 are the matching output values ("Operating Expense"). Those can be a reference to another sheet, or wherever else you want to have them, they don't actually have to be in K1:L10 specifically.
Please Login or Register to view this content.
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks