Question about Microsoft Excel for PC

I would create more columns as such

|__A__|______B____|___C___|_____D____|___E___|_____F____|___G__|

NAME EXERCISE1 REPS1 EXERCISE2 REPS2 EXERCISE3 REPS3

That way you can use VLOOKUP and make sure you include the appropriate column in the VLOOKUP(NameOfPerson,A:G,3) this will get you the reps for exercise1

VLOOKUP(NameOfPerson,A:G,5) this will get you the reps for exercise2

etc.

Doing it this way will also make it easier to add more exercises. It will be worth the time of converting what you already have. But if you have hundreds of thousands of people then I might be able to write a quick Visual Basic program to convert what you have.

Posted on Jul 17, 2009

Select all columns

clik on data click filter select autofilter

Posted on Jul 13, 2009

Hi,

a 6ya expert can help you resolve that issue over the phone in a minute or two.

best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).

click here to download the app (for users in the US for now) and get all the help you need.

goodluck!

Posted on Jan 02, 2017

Check your formulae for a small error. Use F1 to guide you.

Jul 14, 2017 | The Computers & Internet

Sounds like your issue can be solved readily with a pivot table.

If you give the columns of names a title like "NAME" and the number columns a name like "VALUE". All other columns should contain a unique name.

Then select the entire table, including the labels at the top ensuring that the range extends entirely over the column you need to sum the values of.

In Excel 2013, choose the INSERT menu and select the PIVOT TABLE command.

Insert the Pivot table into a new worksheet.

A new sheet will open with a strange-looking control panel on the right of the window.

Make sure that the box for NAME and VALUE (only) are checked

You will notice that Excel assumes that you want the SUM of the values for each NAME summed. The results are in the leftmost area of the worksheet.

If this works for you, please vote my answer as "helpful".

If you give the columns of names a title like "NAME" and the number columns a name like "VALUE". All other columns should contain a unique name.

Then select the entire table, including the labels at the top ensuring that the range extends entirely over the column you need to sum the values of.

In Excel 2013, choose the INSERT menu and select the PIVOT TABLE command.

Insert the Pivot table into a new worksheet.

A new sheet will open with a strange-looking control panel on the right of the window.

Make sure that the box for NAME and VALUE (only) are checked

You will notice that Excel assumes that you want the SUM of the values for each NAME summed. The results are in the leftmost area of the worksheet.

If this works for you, please vote my answer as "helpful".

Sep 03, 2014 | Microsoft Excel for PC

The VLOOKUP and HLOOKUP functions contain an argument called range_lookup that allows you to find an exact match to your lookup value without sorting the lookup table

I have posted below link to know more .Please have a look..

http://www.howtodothings.com/computers-internet/how-to-use-the-vlookup-and-hlookup-functions-in-microsoft-excel

http://support.microsoft.com/kb/181213

http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx

http://www.timeatlas.com/5_minute_tips/general/learning_vlookup_in_excel

Please rate & vote if you like soution..

Thanks

Sandeep

I have posted below link to know more .Please have a look..

http://www.howtodothings.com/computers-internet/how-to-use-the-vlookup-and-hlookup-functions-in-microsoft-excel

http://support.microsoft.com/kb/181213

http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx

http://www.timeatlas.com/5_minute_tips/general/learning_vlookup_in_excel

Please rate & vote if you like soution..

Thanks

Sandeep

Mar 14, 2011 | Microsoft Excel for PC

=VLOOKUP(A2;Sheet1.$A$3:D27;2;0)

The cell I created this formula in was Sheet 3 Cell C9 - to show the different sheets

A2 is the cell I want to look up

Sheet1.A3:D27 is the range of cells that contains the data I want to return, The first column relates directly to cell C9 is Sheet 3. I locked the first cell in my range as I wanted to apply the same formula across other cells hence the $

2 is the number of the column that has the data I want to return, I had a choice in this formula of 4 columns

0 is the value to complete the formula

The cell I created this formula in was Sheet 3 Cell C9 - to show the different sheets

A2 is the cell I want to look up

Sheet1.A3:D27 is the range of cells that contains the data I want to return, The first column relates directly to cell C9 is Sheet 3. I locked the first cell in my range as I wanted to apply the same formula across other cells hence the $

2 is the number of the column that has the data I want to return, I had a choice in this formula of 4 columns

0 is the value to complete the formula

Feb 11, 2009 | Microsoft Excel for PC

An implementation of the vlookup in Excel could be:

You have an Excel table with student names and their grades.

You wish that you could somewhere in the sheet type a student name, and immediately retrieve his grade (based on the data in the table).

To achieve this, you can use "Vlookup": the function will look for the student’s name in the first column in the table, and will retrieve the information that is next to his name in the second column (which is his grade).

Hlookup is the same excpet it is for data arranged by rows instead of columns.

You have an Excel table with student names and their grades.

You wish that you could somewhere in the sheet type a student name, and immediately retrieve his grade (based on the data in the table).

To achieve this, you can use "Vlookup": the function will look for the student’s name in the first column in the table, and will retrieve the information that is next to his name in the second column (which is his grade).

Hlookup is the same excpet it is for data arranged by rows instead of columns.

Dec 29, 2008 | Microsoft Office Home and Student 2007...

You probably need to organise your pricelist sheet so that you only have 2 columns, product and price. If this doesn't fix you, please provide the syntax of your vlookup code.

Dec 10, 2008 | Microsoft Excel for PC

Hi Hss Holdings,

The easiest way to do this is to use a formula called vlookup. You need to have the raw data some where in the workbook, but it can be a separate sheet. Put all the raw data in a table, make sure the account number is on the furthest left column, then start entering the formulas

vlookup(value_to_find, table_to_check, column_index_number, range_lookup(true/false))

value_to_find = the value you want to find on the left most column of the table

table_to_check = the table you want to find the data from

column_index_number = the column number of the data field you want to return into this cell, 1 = the left most column.

range_lookup = false for an exact match, true for the nearest match

Say the table is on sheet2 between A1 and E300

B15 is whatever you type, so no formula needed here

B12 =VLOOKUP(C1,Sheet2!A1:E300,2,FALSE)

G12 = B12 =VLOOKUP(C1,Sheet2!A1:E300,3,FALSE)

etc

The easiest way to do this is to use a formula called vlookup. You need to have the raw data some where in the workbook, but it can be a separate sheet. Put all the raw data in a table, make sure the account number is on the furthest left column, then start entering the formulas

vlookup(value_to_find, table_to_check, column_index_number, range_lookup(true/false))

value_to_find = the value you want to find on the left most column of the table

table_to_check = the table you want to find the data from

column_index_number = the column number of the data field you want to return into this cell, 1 = the left most column.

range_lookup = false for an exact match, true for the nearest match

Say the table is on sheet2 between A1 and E300

B15 is whatever you type, so no formula needed here

B12 =VLOOKUP(C1,Sheet2!A1:E300,2,FALSE)

G12 = B12 =VLOOKUP(C1,Sheet2!A1:E300,3,FALSE)

etc

Jul 12, 2008 | Excel (SS8SATAS5128400R)

If you can move your name column (C) to the first column, you could leverage the VLOOKUP formula pretty easily.

To do this, do the following:

1) Move the C Column to be the A Column, shifting all other columns to the right.

2) (optional) Insert a new row at the top of the sheet (to hold the formula & seach value)

3) Use A1 as your search field.

4) In A2, enter the following formula:

=VLOOKUP($A$1,$A$2:$C$6,3,)

Describing above parameters, in the formula:

$A$1 -> the search field (name your looking for).

$A$2:$C$6 -> The table/grid you wish to search and return values from. The left most column (A) must contain the values to be searched.

3 -> is the column number (A=1,B=2,C=3, etc) within the table/grid to return.

If you cannot make the name column your first (A) column, there are more complex ways to do this. For instance, create a new sheet which redisplays the info in the structure easier for this method, and perform the VLOOKUP on that data. Other options might exist in creating a complex formula that would get you what you want.

Also, if you can sort column A (names) it would find results faster, if your data set is large.

To do this, do the following:

1) Move the C Column to be the A Column, shifting all other columns to the right.

2) (optional) Insert a new row at the top of the sheet (to hold the formula & seach value)

3) Use A1 as your search field.

4) In A2, enter the following formula:

=VLOOKUP($A$1,$A$2:$C$6,3,)

Describing above parameters, in the formula:

$A$1 -> the search field (name your looking for).

$A$2:$C$6 -> The table/grid you wish to search and return values from. The left most column (A) must contain the values to be searched.

3 -> is the column number (A=1,B=2,C=3, etc) within the table/grid to return.

If you cannot make the name column your first (A) column, there are more complex ways to do this. For instance, create a new sheet which redisplays the info in the structure easier for this method, and perform the VLOOKUP on that data. Other options might exist in creating a complex formula that would get you what you want.

Also, if you can sort column A (names) it would find results faster, if your data set is large.

Feb 03, 2008 | Microsoft Excel for PC

Vlookup: =VLOOKUP(A1,A1:C10,3,FALSE)
1. Lookup_value - A1 the value you want to search.
2. Table_Array - A1:C10 You will only search the lookup_value in the left column which is A1:A10 in this example.
3. Col_Index_Number - If you find a matching value give me column 3. Since A1=A1 it will give me C1. In this example 1 is A, 2 is B and 3 is C.
4. Range_lookup - I always choose false which is exact match. True will give you approximate match and its not always correct.
Vlookup is used when you have a list of values and you want additional values that exist in other fields. You will get those values only for the fields that you search for. In your example you can get the address by running vlookup at the names, it is also good way to search duplicates.
Q2 is very simple, on field D1 just type:
=A1 & " " & B1 & " " & C1
Just drag it or double click on the drag square
Let me know if you have any other questions
Daniel

Sep 24, 2007 | Microsoft Office Standard for PC

VLOOKUP is to Searches for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify in the table. Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of the data you want to find.
The V in VLOOKUP stands for "Vertical."
Syntax
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
Lookup_value is the value to be found in the first column of the array. Lookup_value can be a value, a reference, or a text string.
Table_array is the table of information in which data is looked up. Use a reference to a range or a range name, such as Database or List.
If range_lookup is TRUE, the values in the first column of table_array must be placed in ascending order: ..., -2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise VLOOKUP may not give the correct value. If range_lookup is FALSE, table_array does not need to be sorted.
You can put the values in ascending order by choosing the Sort command from the Data menu and selecting Ascending.
The values in the first column of table_array can be text, numbers, or logical values.
Uppercase and lowercase text are equivalent.
Col_index_num is the column number in table_array from which the matching value must be returned. A col_index_num of 1 returns the value in the first column in table_array; a col_index_num of 2 returns the value in the second column in table_array, and so on. If col_index_num is less than 1, VLOOKUP returns the #VALUE! error value; if col_index_num is greater than the number of columns in table_array, VLOOKUP returns the #REF! error value.
Range_lookup is a logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match. If TRUE or omitted, an approximate match is returned. In other words, if an exact match is not found, the next largest value that is less than lookup_value is returned. If FALSE, VLOOKUP will find an exact match. If one is not found, the error value #N/A is returned.
Remarks
If VLOOKUP can't find lookup_value, and range_lookup is TRUE, it uses the largest value that is less than or equal to lookup_value.
If lookup_value is smaller than the smallest value in the first column of table_array, VLOOKUP returns the #N/A error value.
If VLOOKUP can't find lookup_value, and range_lookup is FALSE, VLOOKUP returns the #N/A value.

Aug 30, 2007 | Microsoft Office Standard for PC

Jan 28, 2016 | Microsoft Excel for PC

Dec 12, 2013 | Microsoft Excel for PC

Jul 23, 2013 | Microsoft Excel for PC

134 people viewed this question

Usually answered in minutes!

×