Question about Microsoft Office Home and Student 2007 Spanish Version: Windows

1 Answer

Hi! I have a spanish version of the excell,I don´t know what would be the abbreviation to use the formula of vlookup!Do you think you could help me with that?!

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Brigadier General:

    An expert that has over 10,000 points.

  • Master
  • 5,158 Answers

Operaciones de búsqueda that's look up from english to spanish if that assists you

Robert

Posted on Jan 13, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

What is formula new excell


I certainly can't take the time to explain v lookup to you in this forum, but I can direct you to several sites that you can familiarize yourself with it. It's going to take you time to to understand it.

http://spreadsheets.about.com/b/2008/03/17/excel-vlookup-3.htm

http://spreadsheets.about.com/od/excelfunctions/ss/vlookup.htm

http://www.techonthenet.com/excel/formulas/vlookup.php

Jun 21, 2009 | Microsoft Business & Productivity Software

1 Answer

Vlookup in 2004 excel for mac o/s


First make sure there is an "=" sign at the beginning of the formula.  If there is and the formula still shows in the cell go to Preferences and click View.  Make sure the "Formulas" box under Window Options is not checked.

Jun 04, 2009 | Microsoft EXCEL 2004 for Mac

4 Answers

Dont understand how to use vlookup in excel 2007


This tutorial also helped me much to understand how vlookup works:

http://www.myhowtoos.com/en/excel-howtoos/84-how-to-match-values-in-excel-using-vlookup

Feb 18, 2009 | Microsoft Business & Productivity Software

4 Answers

How to use vlookup in openoffice using different sheets


=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

Feb 11, 2009 | Microsoft Excel for PC

1 Answer

VLOOKUP FORMULA PROBLEM


VLOOKUP(A1,Sheet2A2:B20,2,FALSE)

The assumption here is A1 in Sheet 1 is the cell you want to reference, This cell can be pasted - Any problems let me know.

Jan 21, 2009 | Microsoft Excel for PC

1 Answer

H look up


Hi vrusha,

Your right hlookup is very simular to vlookup, the key difference is it searches along the top row of the table, finds the matching data and gives you one of the below cells (depending on how you write the formula), just think of a vlookup on it's side.

The formula works like this:
=HLOOKUP(lookup value, table, row_index_number, range_lookup)

lookup value = is the value you want to match against the table i.e. ABBA

table = the range of cells that make up the table you want to search i.e. A1:D300

row_index_number = the number of rows from the top of the table you want to get the value from, 1 is the top of the table, 2 is directly below

range_lookup = if you want an exact match type FALSE, if you want the nearest match type TRUE

Jul 17, 2008 | Microsoft Office Professional 2007 Full...

1 Answer

Excell vlookup formula


Suggest you do some debugging in steps:

1. Open the 'bills up to 022908.xls'

2. Use an empty cell to "=CONCATENATE(D3,L3)". That way you can see what values are being generated.

3. Copy the values of that cell and see if you can find them in Col G of 'bills up to 022908.xls'.

Once its broken down into pieces you can usually see "the error of your ways."

Hope this helps.

Mar 09, 2008 | Microsoft Excel for PC

1 Answer

Excel formula of vlookup


hi there
this is i found for you ...and i hope this would give you what you are looking for..

http://www.contextures.com/xlFunctions02.html

All the Best.

Was this solution helpful? Show your Appreciation by rating it:

Feb 20, 2008 | Business & Productivity Software

2 Answers

EXCEL ALL SHORT FORMULA


hiiiiiii
u know vlookup function,then piviot table
u know na tell short formula
genious...

Dec 14, 2007 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Office Home and Student 2007 Spanish Version: Windows Logo

163 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...