if statement index match

  1. B

    If statement question

    Hello all! MrExcel newbie here. I'm trying to create an If statement, I'm assuming an If statement, that can define a cell based on where it falls in a range of numbers. It's for housing development project. I'm attempting to solve for the Status As shown below, if the resident earns above...
  2. A

    if statement with index match understanding

    Hi I have been given this formula but I don't understand some parts in the false section, please could someone explain the parts of the formula to me in detail, especially what the (1- means many thanks in advance {=IF($U2="Fuel...
  3. D

    IF statement and Column Search help

    Link <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style><bdo dir="ltr">=INDEX(Student,MATCH("Teacher 2",Teacher,0)) <bdo dir="ltr">=IF($A$2=INDEX(Student,MATCH("Teacher 2",Teacher,0)),OFFSET(INDEX(Student,MATCH("Teacher...
  4. U

    match INDEX,V-LOOKUP, IF STATEMENT? CONFUSED! HELP NEEDED

    <tbody> A B C D E F 1 YELLOW RED GREEN PINK SILVER 2 ORANGE X 3 APPLE 4 GRAPE X X 5 KIWI X X 6 BANANA X X </tbody> <tbody> Kiwi Formula? </tbody> I need to list the ??? cell with a formula so that it picks up the column...
  5. S

    Returning Debtors Balance if Student is youngest in family

    I would like to only return the Family Debtor Balance against the youngest student, so that the total database = my Debtors Control account. For Example: <tbody> FAMILY CODE Class STUD ORDER BALANCE STEFJ P1 3 1000 DOCHM P1 1 2000 WEARA S2 1 1000 MCARS S3 2 1500 LAIRD P2 1 1800...
    • Stef56
    • Thread
    • if statement index match lookup function match - if
    • Replies: 7
    • Forum: Excel Questions
  6. J

    If statement with Match & Index

    I'm trying to create a formula to scan for certain GL codes in the row headers. If the intersected codes match, then add each value up. (i.e. Column A headers GL codes 6310 + 6500 + 6510 + 6540, their values to the right - Column B $345, $456, $567, & $678). Here is a sample of data...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top