Seeking help in using a Function / Formula in Excel

[Swapna Thakur]

Hi Friends,

I tried to implement the formula of "IF", but I’m unsuccessful in deriving the end results looking for.

However, I've have uploaded the spreadsheet for the ease of doing thing better and safer.

In the attached spreadsheet you'll be finding the data from column A to column O which is system generated and, from column P to column V the data is calculated manually as per the formula / data showing the headings.

Off-course, to some extent my formula is working 100% but for very large amount of data I'm facing
challenge.

For instance, if you see the column O is the Actual Data which I'm trying to get that value in any of the columns P to V.

In my report I succeeded in cell O2 = S2, U2 & V2 and

I failed in cell O7 which does not equal to any cell from P7 to V7, but if you clearly look there is a minor variance of 1 which is in cell T7.

First of all, I want to derive at the value that is exactly matching my column O values or with a tolerance of +/- 100, after this step if any of the cells P, Q, R, S, T, U &V is reconciled to column O value in a chronological order, then the first matching value should populate in Columns W to AC the data should populate accordingly as per row heading.

For your understanding, the first attribute which is reconciled exactly to the value in cell S2 when compared with O2, I'veWalk request.xls given my comments in cell Z2 as Other Income.

Looking for your further help in successfully completing my request.

Thank you,
Swapnaa.

[protonLeah]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.

[dredwolf]

so for O7 value matches T7 within your +/- 100 and a note should wind up in Divedend + Interest Column(cell AA7) ?
and what exactly are your looking to see in that column? "divedend + interest" or "true" or the actual number at O7 or T7?
not really sure what the expected output is supposed to look like, sorry

[jeffreybrown]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.