Question about Microsoft Excel for PC

2 Answers

How to use vlookup

I sir i want to how many use to excel formulas vlookup

Posted by on

  • Anonymous Apr 08, 2009

    I have a problem with v lookup - the formula is typed in correctly but it keeps returning n/a even though a match is there. Any ideas why it keeps going wrong - would it be the formatting??

×

2 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 407 Answers

VLOOKUP is generally used for referencing a cell back to a range listed in columnar format to give a predertermined value.

However - its limitations are the range has to match, so it will work perfectly if the text, numbers match exactly and will not work if there is there is a small difference.

=VLOOKUP(O35,N5:O30,2,FALSE)

To explain the formula - This is cell N35
O35 contains the data I want to lookup
N5:O30 contains the data range that it is referencing
2 is column number that I want to return the value from
FALSE is if there is no match and to complete the formula.

Posted on May 22, 2009

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Governor:

    An expert whose answer got voted for 20 times.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

  • Expert
  • 127 Answers

You can a tutorial here.

please rate.

Posted on Feb 06, 2009

2 Suggested Answers

CNewton2
  • 26 Answers

SOURCE: 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.

Posted on Mar 10, 2008

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Sir i want to know about excel formulas please give me. my email.add. amarsri@hotmail.com


how can we do vlookup two sheet on excle?

E.g

Sheet1 Sheet2
Class Marks

here there are two types of Sheets.If i want to combiend two sheet via vlookup.could you teach me what should do i for same ASAP.

thaks.

Jun 25, 2009 | Microsoft Excel for PC

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 Computers & Internet

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 Computers & Internet

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

2 Answers

Vlookup


Check if the first parameter entered is of the cell for which you are doing lookup.

I mean sometimes its possible if you want to do a lookup for say cell A2, by mistake you enter it as =vlookup(A3,........)

Jul 07, 2008 | Microsoft Excel for PC

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 | Computers & Internet

Not finding what you are looking for?
Microsoft Excel for PC Logo

206 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2635 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18330 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...