Solved

IF cell equals certain value then display text in cell

Posted on 2016-10-11
4
44 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 33

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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

691 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