Get instant live Excel expert help to learn how to use Large function?

I am trying to use the VLOOKUP function in a large chart of BMI data. I want to display 'Underweight', 'Normal', 'Heavy Weight', or 'Obese', depending on the various BMI amounts. How can I use VLOOKUP to 1) find the actual BMI number(s) in the table used to compare, 2) use the legend of reference BMI amounts with the text labels 'Underweight', etc. If possible, I could send the workbook to help you understand. Thanks!

Hello, I am going through a large database and searching for rows which contain a certain word. When I use the find and replace function I get 99 entries. I want to transfer just these rows onto a separate spreadsheet - how can i do it without having to copy each one manually?

i am working in a large file and i want to extract data out of cells which are not in same format nor in same order i know mid right left etc and tried many combinations its not working need some help as data is not formatted i even cant do search dont know what to do

Need to practice with a professional. Need to master VLOOKUP for a relatively large spreadsheet

I have a large list of around 500 companies that I need to highlight in another sheet.

I have a large data table that assigns each row of data to multiple clusters. I need to do some calculations to get weighted averages of data for each cluster.

I have a bar chart with two categories on the x axis and within those two categories are 5 subcategories. The y axis is numerical and the same for all. There is a large gap between the two main categories that I can't format to get rid of.

I have one large trade blotter worksheet, and a couple smaller worksheets with different data that needs to be in the large worksheet. I need a function to make sure none of the smaller data is missed in the larger worksheet. Vlookup wont work because data is not in the same format

I need to create a MACRO where in one sum cell A response times are selected for only the correct answers, and another sum cell B where response time are selected only for the incorrect answers. I have a large dataset where people have been tested on a game and have either right or wrong answers.

I have large Excel 2011 (Mac) spreadsheet that the values in two sheets have suddenly become hidden in the worksheet but do appear in the formula box. Google issue shows special number format ;;; can hide cell content but this was not done or used .. and attempts to re-format cells back to general or other do not return cell contents back to visible. Strangely the workbook works fine when viewed on another computer running later OSX but this problem only occurring when viewed on earlier OSX 10.6 version. The problem sheets were fine when originally started working in OSX 10.6 but after working several hours the problem occured