The old "if" then" thing

[khank]

See attached sample...

If in D a number appears I then what to pickup the appropriate percentage from B associated with that number from A and place in E.

[Ace_XL]

Use

=IFERROR(VLOOKUP(D1,$A$1:$B$27,2,FALSE),"")
or
=IFERROR(INDEX($B$1:$B$27,MATCH(D1,$A$1:$A$27,0)),"")

[Kevin UK]

Hi khank

One option could be the INDEX & MATCH

=INDEX($B$1:$B$27,MATCH(D1,$A$1:$A$27,0))

[khank]

Thanks to the both of you - all three samples work - again one question and many ways to solve the problem...thanks