selection based results formula

  • Thread starter Thread starter Dave Peterson
  • Start date Start date
Assuming your table is as follows:

Column X - contains the numbers that you will enter in Column A
Column Y - contains the "possibilities"

Enter the following formula in Cell B1 and copy down until Cell B20:

=vlookup(A1,$X$1:$Y$20,2,0)

Hope this will help you.
 
hey its a simple thing , write an IF then formula, in column A , and
likewise all things would appear in column B.

Like
type the underwritten code in cell B1
=if(a1=15,"Staff Wages",if(a1=18," Product wages"))

Hope it helps!

Jim
 
I need a formula that will display one thing in column "B" based on the
entry in column "A". There would be 20 different possibilities depending on
the entry in column "A"

Example:

If "15" is entered in column "A" then "Staff Wages" would appear in column
"B"; if "18" was entered in column "A" then "Production Wages" would appear
in column "B"

Hope someone can help.
 
Exactly what I needed, thanks


BenjieLop said:
Assuming your table is as follows:

Column X - contains the numbers that you will enter in Column A
Column Y - contains the "possibilities"

Enter the following formula in Cell B1 and copy down until Cell B20:

=vlookup(A1,$X$1:$Y$20,2,0)

Hope this will help you.
Click to expand...
 
Back
Top