f12

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...

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...

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...

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...

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...

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...

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,

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...

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...