Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLOOKUP & IF or Sumproduct
My dilemma today is, how to have Cell A1 fill automatically with CTA, or STD,
or GIL, or STA when the following conditions are true. if Cell C1 is "a" & Cell B1 is "401n", or "401s", or "402n", or "402s" then Cell A1 will = CTA if Cell C1 is "c" & Cell B1 is "401n", or "401s", or "402n", or "402s" then Cell A1 will = STD if Cell C1 is "a"& Cell B1 is "501n", or "501s", or "502n", or "502s" then Cell A1 will = GIL if Cell C1 is "c" & Cell B1 is "401n", or "401s", or "402n", or "402s" then Cell A1 will = STA The number text combination (401n) is in column B before I receive the file. I would like to enter the a or the c in column C and have the proper data auto enter in Column A. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct or VlookUp | Excel Discussion (Misc queries) | |||
Sumproduct and Vlookup | Excel Worksheet Functions | |||
VLOOKUP, IF, SUMPRODUCT...oh my! | Excel Worksheet Functions | |||
VLOOKUP? SUMPRODUCT? not sure how to do this | Excel Worksheet Functions | |||
sumproduct and vlookup | Excel Worksheet Functions |