# f12

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

### This Week's Hot Topics

• Turn fraction around
Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
• TIme Clock record reformatting to ???
Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
• TextBox Match
hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
• Using Large function based on Multiple Criteria
Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
• Can you check my code please
Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
• Combining 2 pivot tables into 1 chart
Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...