Solved

IF cell equals certain value then display text in cell

Posted on 2016-10-11
4
40 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 32

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:Danny Child
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
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.

914 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

14 Experts available now in Live!

Get 1:1 Help Now