Do you need a drop down in column B?
in B2:
=VLOOKUP(A2,Sheet2!$A$1:$B$5,2,FALSE)
Do you need a drop down in column B?
in B2:
=VLOOKUP(A2,Sheet2!$A$1:$B$5,2,FALSE)
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.