Need some quick help with this lookup function

[nativetongue03]

I'm sorry but it's been years since i've used this function or Excel fo rthat matter but I know I have done this before

I have a ASU sheet which has case numbers in D2-D23 and priority rankings in E1-E23.
I have another opencases sheet that has the case numbers in A2-A20 and their details and owners and so on.

I want to setup a lookup formula that will look up the priority of the case

So my approach was to have this formula do it for me:
=LOOKUP(A2, ASU!D2:D23, ASU!E2:E23)

However that formula seems to be doing an average somwhow like if the value in A does not have a ranking or not in ASU1 it defaults to the previous lower ranked

I am sure i have done similar lookups before in the past but my excel skills have since deteriorated

Would vlookup be an option?

 

[VoG]

Try

=VLOOKUP(A2, ASU!D2:E23,2,FALSE)

 

[nativetongue03]

Try

=VLOOKUP(A2, ASU!D2:E23,2,FALSE)

YESSSS!!!

That worked perfectly.

Thanks