When you search a range of data, for example, by using the VLOOKUP function, the search is always performed by using a unique criterion. How to perform multiple searches or quickly change criteria? In the following text, you will learn about the DGET function, which allows for greater flexibility and easier finding of the required values in a given range.
When you enter phone numbers in a cell, you must enter them as text which means that you should add an apostrophe before entering the number. In this case, it is best to enter the number in international format. If you don’t want to think about codes and calling numbers, you can retrieve this data from the auxiliary records, and then join them with the help of the TEXTJOIN function. You will find out how to enter email addresses and phone numbers in the following text.
When working with large tables, it is often necessary to make their search easier. One of the ways to do this is by applying the option for conditional formatting, with which we can mark all rows in which a value corresponding to the given criteria was found. In the next “recipe” you will find out how to perform such task.
Microsoft is constantly working to improve the user experience and make everyday work in Excel easier. A few years ago, the „Tell me what you want to do“ option appeared, and later its functionality was integrated into the Search field, which you can still see in the title bar of any Excel document. Search is now part of the context menu, and browsing Excel features is even easier than before…
Many years ago I worked for ECOFINANCE company where, at my time, I wrote an Excel invoicing application. It seems to me that it was quite easy to use. Partly because it was enough to enter part of the name of the code or product to find the desired item. The seller would then only select the quantity and packaging and could quickly continue to enter items until the document is completed. Today this can be achieved much easier, without any VBA programming …