Does anyone know of a function I can use to look up a cell based on multiple
conditions? I'm looking for something similar to the Sum(if((array-x=y),
array-z,0)) formula but it would return text and not a sum. Sort of a vlookup
with multiple conditions.
Thanks for your help.
Christine
=INDEX(Range_with_text_value,MATCH(1,(array-x=y)*(array-z=next_condition),0)
)
entered with ctrl + shift & enter
--
Regards,
Peo Sjoblom
"cambrus" <cambrus@discussions.microsoft.com> wrote in message
news:67DD0E7A-C9A9-47FD-9C9B-3CC13478D2F8@microsoft.com...
> Does anyone know of a function I can use to look up a cell based on
multiple
> conditions? I'm looking for something similar to the Sum(if((array-x=y),
> array-z,0)) formula but it would return text and not a sum. Sort of a
vlookup
> with multiple conditions.
>
> Thanks for your help.
>
> Christine
iceordo,Hi
I would like to know how i can use max or min dates and using vlookup at the same time. Probably i cannot use vlookup. There should be other functions i need to use. Please advise on the matter. Here is an example shown below. Thanks in advance.
Date Item
1/1/2013 x
1/10/2013 y
1/15/2013 y
1/18/2013 x
1/20/2013 z
1/25/2013 y
1/30/2013 x
2/1/2013 z
2/2/2013 z
2/3/2013 x
2/4/2013 z
2/5/2013 x
Item Max date
x ?
y ?
x ?
My question is how can i get the latest dates for x,y and z? Thanks
Regards,
Emre
Welcome to the Forum.
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
Last edited by arlu1201; 02-06-2013 at 10:31 AM.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
I was not able to create my own thread. And i have sent many messages before asking how to post my own. I did not get any answer. Thanks
Iceordo,
To create your own thread, click on the appropriate subforum. Then click on Post New Thread and proceed.
Are you getting any error when you attempt it?
I clicked on the related subforum and there is no such a thing as Post New Thread. There is only reply to Thread. Please advise. Thanks
Ok i will move your post to the relevant subforum.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks