I have a question about the lookup function. I use Vlookup quite regularly, but I am in a situation now where items are being added to a lookup list and can't be resorted after the intial list is set up. This gives Vlookup a fit. Is there a way to use a lookup Function in Excel that does not require the list to be sorted.
Any input is much appreciated.
Paul
Any input is much appreciated.
Paul