Question about Microsoft Excel for PC

2 Answers

Vlookup Syntax Hi There I need to compare numbers in column B with numbers in column A and want to return the numbers which are only in B.

Posted by on

2 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points


    An expert that got 5 achievements.


    An expert whose answer got voted for 20 times.


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

  • Expert
  • 104 Answers

Hi, Could you please tell me how you want to compare the two sets of figures. Do you want to find a figure in column A and retunr the corresponding from column B or apply some other question on the data?


Posted on Mar 07, 2008

  • Level 1:

    An expert who has achieved level 1.


    An expert that got 5 achievements.


    An expert whose answer got voted for 20 times.


    An expert who has answered 20 questions.

  • Contributor
  • 35 Answers


I am not sure if Vlookup is the right function to use in this case.
A simpler approach may be to use an "IF" statement.

For example, with a data set:

A B 3 17 765 23 8645 45 43 87 634 635 34 31

Let assume you wanted to compare if A was greater than B and if true return B. If false return a 0.

=IF((A3-B3)>0,B3, 0)

The results would look like this:

A B Results 3 17 0 765 23 23 8645 45 45 43 87 0 634 635 0 34 31 31

Posted on Feb 28, 2008

1 Suggested Answer

  • 2 Answers

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

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

Add Your Answer

Uploading: 0%


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



Related Questions:

3 Answers

What is vlook up & what is hlook up?

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

Please rate & vote if you like soution..


Mar 14, 2011 | Microsoft Excel for PC

4 Answers

Dont understand how to use vlookup in excel 2007

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

Feb 18, 2009 | Microsoft Computers & Internet

4 Answers

How to use vlookup in openoffice using different sheets


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

2 Answers

How to use vlookup

you can a tutorial here.

please rate.

Feb 06, 2009 | Microsoft Excel for PC

1 Answer

Need to use the VLOOKUP formula for more then one column

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

2 Answers


Just noticed a small syntax problem, try this:

I always add the last parameter of "0" to insure that that an exact match is found.

Jul 27, 2008 | Computers & Internet

2 Answers

I have been trying to get this formula or function to work all day

You might try looking/posting on forum sites like
That has helped me with different things, especially correct syntax.


Jul 27, 2008 | Microsoft Computers & Internet

1 Answer


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.

Feb 03, 2008 | Microsoft Excel for PC

3 Answers


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

1 Answer


Hi Ralph, On the first table If the name is in column A and dept is in B. Suppose the new names are in column D here's the formula =vlookup(D1,A:B,2,0) Note a few things - 1. You will only receive the 1st departament. 2. In case that the name in D doesn't appear in A you'll get N/A. This can be solved using the following formula: =if(type(vlookup(D1,A:B,2,0))=16,"",vlookup(D1,A:B,2,0)) Let me know if there's anything else. D.

Aug 27, 2007 | Microsoft Office Standard for PC

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

60 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