Please help,

If a worksheet with A, B, C & D fields, so
when VLOOPUP every time switching (looking)
from field A to D, or to C then sorting to
that perticular field is needed?

Is there any better solution ?

thank so much!