Question about Microsoft Excel for PC
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:
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.
Posted on Feb 04, 2008
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.
Posted on Jan 02, 2017
Tips for a great answer:
Feb 15, 2013 | Microsoft Excel for PC
Feb 28, 2011 | Microsoft Office Standard 2007: Windows
Sep 06, 2009 | Microsoft Office Professional 2007 Full...
Jul 08, 2008 | Microsoft Computers & Internet
May 27, 2008 | Microsoft Excel for PC
May 16, 2008 | Microsoft Excel for PC
Apr 09, 2008 | Microsoft Excel for PC
Jan 07, 2008 | Computers & Internet
Oct 10, 2007 | Microsoft Office Standard for PC
Aug 27, 2007 | Microsoft Office Standard for PC
Jan 28, 2016 | Microsoft Excel for PC
171 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: