If statements for multiple cells

[DukeRollo]

Suppose I have 5 names.

Alex
Becky
Cedric
Darlene
Eric

Suppose each of these folks have an order that I have to deliver to and some are VIP's. For example, Darlene will always get her package first before Alex.

1 Darlene
2 Cedric
3 Alex
4 Eric
5 Becky

What I am looking for is a formula that will look at the list of names and perform logic such that if the primary name is present in the list, it will return that name. If that name is not on the list, it will return the next name.

So if the list of names were

Alex
Eric
Eric
Eric [he has multiple deliveries, let's say]
Darlene

The formula would come back with "Darlene".

[Sam Capricci]

Look into vlookup or index/match. To get a better formula mock up an example and upload it - go advanced to upload one.

[Special-K]

Where D is your second table and C is your first
=MIN(MATCH(D1:D5,C1:C5,0))
Array formula, use Ctrl-Shift-Enter

[Sam Capricci]

Here you go DukeR, I mocked up an example for you...

using index/match against a list I created in E:F and the people beginning in A2 =INDEX($E$2:$E$6,MATCH(A2,$F$2:$F$6,0)

[DukeRollo]

You guys are the best! Thank you.

[Special-K]

Ignore this post.

[Sam Capricci]

you're welcome and if that takes care of your issue don't forget to mark the post as solved using the thread tools dropdown at the top of the post.