Conditional Formula in Different Worksheets

Sponsor

Excel Formulas Question:

I have two excel worksheets
Excel Worksheet 1 has the primary input
Column A1: M Column B1: $12.5
Column B1: S Column B2: $17.00

While Excel Worksheet 2 has a value of M or S in column B and a number in column A, I want to have the formula look up the letter in Column B excel worksheet 2 for a match in Excel Worksheet 1 and determine if it is an M or S and then return the value of $12.50 or $17 and then multiply it by column A in Excel Worksheet 2. The answer will be in Excel Worksheet 2.

Excel Formulas Answer:

Not sure about having S and 12.5 in B1? But the basic idea of your condition excel formula is if you want the result in C1 of sheet 2
=VLOOKUP(B1,A$1:B$2,2,)*A1

Rate This Tips:

Incoming excel search terms

free excel formulas worksheets,multiplying all rows in column a with column b1,!! worksheet conditional formulas,$1$2 excel formula,add conditional formula excel,basic excel formulas with worksheetsl,compare column a in worksheet 1 with column a in worksheet 2 using conditional formatting,compare columns in different worksheets,conditional exel worksheets,conditional formula in different worksheets in excel,conditional formular in excel return #value,conditional formulas in excel,conditional formulas in excel different worksheets,different formula in excel,different formulas in excel,different lines in xcel worksheet,excel formula different,excel formula for dates on worksheets,excel formula from different worksheet,excel formula in different worksheet with date input,excel formula look up from a different worksheet,excel formula on different worksheets,excel formulas,excel formulas different worksheets,excel formulas for two worksheets,excel formulas from different worksheets,excel formulas multiply different worksheets,excel questions formulas worksheet,excel tips conditional formula,excel worksheet formula,exel formulas in different worksheets,formula different column in excel,formula for 3 different criteria in 3 columns excel,formula with a different worksheet,if formula in excel on different worksheet,multiply columns in xcel,use condition to delete rows in different work sheets,writing conditional formulas in excel,xcel work sheets,year date calculation of different worksheets,year formula different worksheet

Related Excel Tips

• Using Percentile with Specific Cell in Worksheet (0)
• Look to Cell References to a Worksheet (0)
• Intersection of Two Tabs in Excel Worksheet (0)
• Calculate Age from Two Date Cells (3)
• Writing a Formula Which Dynamically Generates Results (0)
• IF Statement Calculating Average Has Numeric and Text (0)
• Automatically Insert Number of Days in Specific Month (0)

Comments

• Archives

  • October 2009
  • September 2009
  • August 2009
  • July 2009
  • June 2009
  • May 2009
  • April 2009
  • March 2009

• Categories

  • Excel Vba
  • Excel Tips
  • Excel Formulas
  • Excel Date Functions
  • Excel Spreadsheet
  • Excel Worksheet
  • Excel Miscellaneous

• Partners

  • Search Xls
  • Xls Files

• Latest Excel Tips

  • Search-Engine-Excel.Com - The Helpful One for You
  • Switch Minutes to Seconds in Excel
  • Excel Polynomial Trendline
  • Sending Multiple Personalized Email from Excel
  • Excel Sumif Multiple Criteria
  • Remove Hyperlinks in Excel
  • Copy Entire Rows to Another Spreadsheet Based on Cell Criteria
  • Streamlining Macro Created by Macros Recorder
  • Copying Cells Which Include Conditional Formatting in Worksheet
  • How to Draw Lines on User Form

• Most Viewed Excel Tips

  • How to Divide a Number With “Less Than” Sign? - 62,334 views
  • Macro VBA to Remove Characters in String of Text - 32,025 views
  • Copy Entire Rows to Another Spreadsheet Based on Cell Criteria - 30,548 views
  • Date Calculation Start Date Minus Year, Month and Days - 27,196 views
  • Excel Sumif Multiple Criteria - 21,397 views
  • Embedded Chart on Worksheet Using Excel Vba - 20,106 views
  • Protect Range of Rows and Columns in Worksheet with Macro - 20,074 views

• Best Excel Tips

  • Calling Macro Visual Basic Procedures of a Different Project (5.00 out of 5)
  • How to Remove Excel Vba Macro Button (5.00 out of 5)
  • Remove Hyperlinks in Excel (5.00 out of 5)
  • Delete Worksheet (5.00 out of 5)
  • Copy from Worksheet (5.00 out of 5)
  • How to Calculate 6 Working Days Between Two Dates (5.00 out of 5)
  • Unprotect Worksheet Password (5.00 out of 5)

• Excel Tags

  Excel Vba vba excel xcel vba vba xcel Excel Tips Excel Formulas excel formula xcel formulas xcel tips excel vba add worksheet excel vba create new workbook excel worksheet formulas xcel formula Excel Worksheet microsoft excel tips excel vba date functions excel date function Excel Spreadsheet excel vba active worksheet excel vba worksheet change excel vba worksheet name excel vba worksheet_change excel vba delete worksheet excel vba select worksheet excel vba clear worksheet excel vba copy worksheet excel vba macro add new worksheet how to add new worksheet excel miscellanous