Solved

IF cell equals certain value then display text in cell

Posted on 2016-10-11
4
36 Views
Last Modified: 2016-10-13
So I have a list of account codes in one column and the names of the accounts in the next column.

I then have a data entry table in which I enter the account code and an income amount $.

I want to make it so that a description column which follows the account number will auto populate upon entering the account code.

So it looks like this:

D6:D20 is account numbers
E6:E20 is account description
F6:F20 is income amount $

Then outside the data table I have the list of account codes and descriptions.
Codes are J3:J21
Descriptions are K3:K21

The thing I cannot figure out is how I can do an IF statement with multiple logics?

There is 15 account numbers and descriptions, the thing is the row in which they will be entered is not always going to be the same..

I mean I know the easy function if it was to always be on the same row..
=IF(D6=J3,"Grant Funding")
0
Comment
Question by:sam excel
4 Comments
 
LVL 1

Accepted Solution

by:
Andrew White earned 500 total points
ID: 41837976
No need to use IF.

If understand your layout correctly, try =vlookup(d6,$J$3:$K$21,2,0)
0
 
LVL 31

Expert Comment

by:Rob Henson
ID: 41838025
To add error trapping if an invalid account code is entered:

=IFERROR(VLOOKUP(D6,$J$3:$K$21,2,FALSE),"Invalid Account")

Alternatively, to not allow invalid codes in the first place, apply Data Validation so that the user can select from a dropdown of valid codes.
0
 
LVL 23

Expert Comment

by:DanCh99
ID: 41838197
I think the guys above have nailed it, but if you have any further questions, an example sheet being attached would help a lot.
1
 

Author Comment

by:sam excel
ID: 41841301
Here is a sample of what I am referring to.

As you can see I basically want the cells in E to populate when a code is entered into D..

But any of those codes can be on any row each day so yeah.
excel-balancing.xlsx
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now