We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Multiple Function on Excel
Options

Cotta
Posts: 3,667 Forumite
in Techie Stuff
Hello Everyone,
This is a tricky function I am trying to perform on Excel, however at present it is not working and I would appreciate some help. I'm going to start again as my previous code got very confusing.
I want to link a unique identifier on my "personal" tab within column A, to column A in "tab2" then in column "B" within "tab2" which is a date tab in (29/10/2007) format, if the year is 2015 I have to return the value within column C of "tab2" otherwise I return the value within column "D" of "tab2".
Can anyone help me with this please?
This is a tricky function I am trying to perform on Excel, however at present it is not working and I would appreciate some help. I'm going to start again as my previous code got very confusing.
I want to link a unique identifier on my "personal" tab within column A, to column A in "tab2" then in column "B" within "tab2" which is a date tab in (29/10/2007) format, if the year is 2015 I have to return the value within column C of "tab2" otherwise I return the value within column "D" of "tab2".
Can anyone help me with this please?
0
Comments
-
Maybe a good idea to go back to basics if it is too complicated. Always good to try and keep it simple. Must admit I forget your original goal but I cannot really understand your explanation. The actual Excel formula are probably not tricky at all but understanding the requirement and converting that to Excel speak could sell be!
Are you trying to find matches in 'personal'? Where does the date come from? Is it not in date number values and just presented in dd/mm/yyyy format.....or is it actual text. These things are very important as to how it is handled. If not a date value why not as it does simplify things.
Can you not post a copy of the sheet, or share it on a shareable drive (eveb with dummy data if it is confidential) as a pic or pics with manually entered data with a few arrows to show which cell that holds a formula where that comes from and an equation that explains what that formula should do?....or forget Excel to start with and explain in common language. Such as I have a list of employee identifiers in one sheet with associated dates of training courses due next to those IDs. On a second sheet I have some of those IDs and want to display next to them which year the courses are required and highlight those expired without training updates e.g. should have been held last year (2015) ......
.......or whatever it is you want.
If nobody can understand what you want we cannot help! Any joy getting a training course or looking at online training? Or is this a test during training? Are you trying to learn formulas or produce a working spreadsheet.....
Help us to help you.......0 -
Does this work?
=if(YEAR(VLOOKUP($A1,Sheet2!$A:$D,2,0)),"2015",vlookup($A1,Sheet2!$a:$D,3,0),vlookup($A1,Sheet2!$a:$D,4,0))
I couldn't test it as on iPad. Also if I were using it I would have the date elsewhere & refer to it so it is easy to change to another year without having to worry about changing other stuff on your sheet.
I have added dollars, but depending on how you are going to use it you could leave these off.0 -
Sorry made a bit of a mess of that response! Hopefully you understand the points. Would rewrite but now well past my bedtime!!!!:rotfl:0
-
OP has previously been advised (nay recommended) to build the formula in stages (in columns that can be hidden), but seems reluctant to follow this advice.
Any problem would immediately become apparent.0 -
OP had been advised many many times to ask these repeated advanced excel questions on a specialised excel forum for more expert advice but seems reluctant to do that too .
http://www.mrexcel.com/0 -
-
They have both been given the same advice but persist on posting here ..
Its akin to going to your GP for general advice, and if the subject becomes more specialised , you would be referred to a consultant.
It sounds like the OP's are trying to build a complicated sheet and are coming back again and again for each step of the way.
I have advised that rather than do this, they get the base understanding of what they are trying to do rather than someone doing it for them, especially if the question is not just a one off kind of thing.
OP - YOU WILL GET MORE SPECIALISED ADVICE ON THE FORUM I POSTED, AND PERHAPS A DEEP EXPLANATION OF WHY THE ANSWER WORKS, ENABLING YOU FOR THE FUTURE0 -
Sorry guys, don't often venture in this part of the forum, try to keep excel for the daytime!0
This discussion has been closed.
Confirm your email address to Create Threads and Reply

Categories
- All Categories
- 350.9K Banking & Borrowing
- 253.1K Reduce Debt & Boost Income
- 453.5K Spending & Discounts
- 243.9K Work, Benefits & Business
- 598.7K Mortgages, Homes & Bills
- 176.9K Life & Family
- 257.1K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 37.6K Read-Only Boards