Here's an example of how to use VLOOKUP. =VLOOKUP(B2,C2:E7,3,TRUE) In this example, B2 is the first argument—an element of data that the function needs to work.For VLOOKUP, this first argument is the value that you want to find.

To resize the image, select the image to see drag handles appear around the image. Move the drag handles to resize the image as necessary. Select the Picture Format tab on the ribbon, then use the options on it to format your image. For example, you can apply a style or a border to the image.

In the Cell link box, enter a cell reference that contains the current state of the option button.. The linked cell returns the number of the selected option button in the group of options. Use the same linked cell for all options in a group.

Read the Software License Terms to review terms on transferring Office. Open an Office application, such as Word. (Here's how to find Office on your computer.)

Windows Hello is a fast, secure, way to sign in to your Microsoft Windows device, and facial recognition makes it even easier. An important part of making it secure is that facial recognition needs to be confident that the face it's seeing in the camera is a live person and not a photograph or other image.

Turn on caret browsing indefinitely by going to Settings and more > Settings > Accessibility and turn on Navigate pages with a text cursor. With caret browsing on, you can move the caret within a web page using the Up, Down, Left, and Right directional arrow keys and Home, Page Up, and Page Down buttons on your keyboard.. To select text, images, or other elements on the page, hold down Shift ...

You can add or review changes and comments as you scroll through a document on your iPad or iPhone. When Track Changes is turned on, Word uses a unique color to mark the changes made by each author.. Manage tracked changes. Text changes appear in a different color than other text.

Notes: To find an item in the Choose commands from list, it may be helpful to first confirm its location and name within the app. Commands that are no longer visible in the app could still be listed here under All commands.To help identify this type of command, a more descriptive tooltip name may appear in parentheses next to the legacy command name in this form:

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

To get support in Outlook.com, click here or select Help on the menu bar and enter your query. If the self-help doesn't solve your problem, scroll down to Still need help? and select Yes.. To contact us in Outlook.com, you'll need to sign in.