Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get a cell value based on different criteria?
I have a simple template that I am trying to set up to do an analysis on our
profit for a line of business. In column A11 am using a Code (BL, EP, PB etc) that will affect the value of the cell in column G12. Ths value is not the same for each of the codes in A11. What "simple" formula can I use to accomplish this. I am guessing I will need a type of validation or lookup but don't know the proper procedures. Thanks BG -- |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get a cell value based on different criteria?
VLOOKUP
In Columns A & B of say Sheet2 have your codes and their corresponding values in G12: =VLOOKUP(A11,Sheet2!A:B,2,false) To allow for A11 value not present in table: =IF(ISNA(VLOOKUP(A11,Sheet2!A:B,2,false)),"Invalid code",VLOOKUP(A11,Sheet2!A:B,2,false)) <A11 could use Data Validation to ensure a valid list based on the codes in your lookup table on Sheet2 and hence remove need for error check. HTH "B G" wrote: I have a simple template that I am trying to set up to do an analysis on our profit for a line of business. In column A11 am using a Code (BL, EP, PB etc) that will affect the value of the cell in column G12. Ths value is not the same for each of the codes in A11. What "simple" formula can I use to accomplish this. I am guessing I will need a type of validation or lookup but don't know the proper procedures. Thanks BG -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
How do I set a cell value based on a formula in another cell? | Excel Discussion (Misc queries) | |||
Locate a cell, based on a criteria, then use the 'Cell' command... | Excel Discussion (Misc queries) | |||
How do I get info from a cell based on criteria from another cell | Excel Worksheet Functions | |||
I am trying to color fill a cell based on specific criteria | Excel Discussion (Misc queries) |