I would like to know, short of manually sorting and then unsorting, if I could have a worksheet sorted automagically when I have clicked on its tab and then unsorted when I click on any other tab.

The sorted worksheet is called DataEntry and the other worksheet is called WorkOrders. When I click on DataEntry I'd like to have that sheet sorted oncolumn "LastName" and then column "AreaCode". When I click on WorkOrders I'd like to have the DataEntry sheet unsorted so that vlookup (in WorkOrders) will work properly.

I suppose a macro could be written to do this but I am not great with macros.

Thanks

On Feb 3, 12:27*pm, Ephraim <rick.mal...@gmail.com> wrote:
> I'd like to have the DataEntry sheet unsorted so that vlookup (in WorkOrders) will work

Do you want this data sorted because you want vlookup to find
particular values first?

If you want vlookup to find exact matches regardless of the way the
data is sorted, make the last argument (Range_Lookup) "False".

Thanks!
Cliff Edwards

On Feb 6, 7:10*pm, ward376 <cledwards1...@gmail.com> wrote:
> On Feb 3, 12:27*pm, Ephraim <rick.mal...@gmail.com> wrote:
>
> > I'd like to have the DataEntry sheet unsorted so that vlookup (in WorkOrders) will work
>
> Do you want this data sorted because you want vlookup to find
> particular values first?
>
> If you want vlookup to find exact matches regardless of the way the
> data is sorted, make the last argument (Range_Lookup) "False".
>
> Thanks!
> Cliff Edwards

To clarify

=vlookup(value,range,2,false) or
=vlookup(value,range,2,0) that's a zero