Question about Microsoft Excel for PC
Have being facing problems using vlookup in openoffice while using different sheets. am looking for sample solution
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
Posted on May 12, 2009
How to use vlookup in openoffice using different sheets plz cn u hlp me.
Posted on Aug 07, 2009
Please show practicly use of VLOOKUP
Posted on Feb 25, 2013
How to convert excel file into openoffice?
Posted on Jul 01, 2010
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:
Jun 03, 2014 | Microsoft Excel for PC
Aug 27, 2010 | Computers & Internet
Jun 12, 2009 | Microsoft Excel for PC
Dec 10, 2008 | Microsoft Excel for PC
Sep 12, 2008 | Microsoft Excel for PC
Mar 23, 2008 | Computers & Internet
Aug 27, 2007 | Microsoft Office Standard for PC
Jan 28, 2016 | Microsoft Excel for PC
4,784 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: