Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

vlookup

ResolvedVersion 2007

Christian has attended:
Excel Advanced course

VLOOKUP

How can I look up all elements which start with a certain common letter (ex: East1, East2, East3 and show all East)

RE: VLOOKUP

Hi Christian

Thanks for your post, sorry its taken me a while to get back to you

To do this what you will need to do is a custom filter so when you go into your auto filters, what you choose is a custom filter, then pick from the list begins with and type in the letter you need, if you want to do 2 lots of things, then make sure you click the OR option before you click OK

Hope this does the trick


If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn

Excel tip:

Closing Multiple Open Worksheets At Once

When multiple Excel worksheets are opening, rather than performing a File > Close menu option multiple times, hold down the the SHIFT key and select the File > Close All menu option.

Close All menu option is only displayed when Shift key is down

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.