f12

  1. brasqo

    Trim function on the same cell in multiple sheets

    Hi everyone, Hoping someone could point me in the right direction. I have a worksheet with multiple sheets that are all identical in layout (an export from another program) I need to trim one cell (F12) in each of these sheets. I've used the following formula on a cell to have it trim...
  2. E

    Alternative Formula

    Good evening, Would it be possible to have an alternative formula to the following as this only returns data if D12 is a alpha numeric value =IFERROR(LOOKUP(2,1/(Data!$AK$3:$AK$502=D12)/(Data!$AD$3:$AD$502=F12),(Data!$X$3:$X$502)),"") this matched D12 within AK3:AK502 and F12 within AD3:AD502...
  3. M

    Multiple VLOOKUP in One Cell

    I have a formula in K12 as seen below =IFERROR(VLOOKUP(F12,Table!A:W,23,FALSE),"") I want to modify it to look at values in both F12 and H12, so I created the following =IFERROR(VLOOKUP(F12&H12,Table!A:W,23,FALSE),"") Even though the formula did not error out (syntax must be correct), I am not...
  4. M

    VLOOKUP help needed

    I have a spreadsheet where I need a cell to look for a specific value in another tab and if it finds that value, to populate a cell with the description in the column specified. I have used this formula before in a different spreadsheet and it worked great. However, in this one it is not...
  5. H

    Income/Expense Formula Help

    I need help creating a formula that basically says: IF E12="Income" then the number typed in f12 will be positive If e12="expense" then the number typed in f12 will be negative Just trying to eliminate some work as I'm a profit and loss analyst and type thousands of numbers a day... Example...
  6. N

    Question about unmerged columns

    I have F12 and G12 as merged cells in an xls file that is exported from Navision. Clicking on F12 and pressing CTRL-Space to select the whole merged area (F:G), it selects a bigger area (A:J) because of some merged cells above F12. But if I click on the column letters F and G, I can select only...
  7. O

    Help on formula =IF(SUMPRODUCT(COUNTIF(H3:H99, B3:B99))>0, "done", "in process")

    Why when using this formula on column f everything above f12 equals Done. When I just want f12 to equal done not everything above it. Thank you,
  8. T

    Lookup formula

    Hi, referring to the attached screenshot, quick to the question: For cell G3, i need to lookup the value of cell B3 (which is "0019" on Day 4229), from B4 to F12. (till the bottom of the table) As "0019" found on cell C8, which is Day 4224, the output on cell G3 will be 4229 minus 4224...
  9. K

    Check multiple column on 2 worksheets and report mismatch

    Hello all, am new to this forum and this is my first post. I have been trying to work on a requirement to check multiple column on two different sheets of a workbook, and report only differences (if any) on a different sheet. I haven't been successful fo far, so any help or idea how to go...

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