Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Double Vlookup

I have a double vlookup problem here.

Here's a simple illustration:

1 1 1 1 One
2 2 2 2 Two
4 4 3 3 Three
3 3 4 4 Four
5 5 5 5 Five

I need to match A,B with E,F.

If they match, I need to display the string in G in C.

View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Double VLookup (vlookup The Same Data From 2 Different Sheets)
I'm currently trying to vlookup the same data from 2 different sheets. Here is the code i've tried.

View Replies!   View Related
Is It Possible To Have A Double VLookup?
On one sheet I have an array of 4 cols. It looks like this:

123 Chris 12345 Jones
123 Chris 23456 Pete
123 Chris 34567 John

On the main sheet there are also 4 cols. In cell A1 I enter a number, in A2 I have a VLookup to get the corresponding name for the number entered in A1, which works fine, I type 123 in A1 and get Chris in A2.

In a perfect world I would like A3 to become a dropdown with 12345, 23456 and 34567 so the user could then select one of those, and by doing so, A4's VLookup would give Jones, Pete or John.

I don't think a dropdown can be populated this way - am I stuck using VBA?

View Replies!   View Related
Trying to do a double lookup, or a conditional lookup. Attached spreadsheet will provide much more clarity. I have multiple data sets within a universal file, each data set can contain the same constituant therefore I would like to lookup/vlookup a value only if the constituant is part of the data set I want to pull from.

In attached sheet: if cells in Col A= "F", then vookup("RDT",(array would be data set "F" (I think)),return value in col 2 (assuming vlookup is in col B), t/f)

View Replies!   View Related
Double Value Vlookup In 2003
I have a spreadsheet of mail types with totals. What I am trying to do is create a formula in the highlighted cells in the second sheet that will look at the Account ID Row for a certain value (in this case '45265637'), then look for all the month (in this case April) then add all the figures for this month in the LETTERS row, with the cell below it doing the one for PACKAGES.

I am exhausted from trying to get this one done. The reason that I need to this is that is I have an Excel system readout of 821 different ACCOUNT IDs and their volumes for everyday from 1st April 08 - 30th June 08 and I need a forumula that will extract this automatically as I don't fancy manually cell referencing 45,000-50,000 cells!

(and I hope the images work!)

View Replies!   View Related
Avoiding Double Vlookup
I am tring to find a more efficient way of avoiding a double Vlookup function.


I have read over this forum but still haven't understood any solutions.

A6 is a name.
The name may not be on the worksheet the function is looking up.

View Replies!   View Related
Double VLOOKUP: Compare TWO Values In TWO Cells
I'm curious if there's a way to use the Vlookup function to compare TWO values in TWO cells with two values in two OTHER cells (same row though) and return one value from another column. Something like

Vlookup(A2 & C2, Sheet2!A1:C400, 3, FALSE & FALSE)....? Does that make sense?

Say the values in A2 and C2 are in A24 and B24 respectively in Sheet2. Can it return C24 for me?

View Replies!   View Related
Double Vlookup For Table Array With Dates
I have a table that shows a row of dates, a row of campaigns, and then a row of values I need to reference. I need to pull the values for a specific date and corresponding campaign.

For example, I need to pull the value for campaign 'notset' on 6/16/09.

I tried the following, but it would only work on the first and last campaign: ...

View Replies!   View Related
Double Sum If
Let me show you how my sheet is set up.

Steeves 10 ny
Steeves 15 ny
Steeves 20 nv
Steeves 5 tn
Steeves 10 ca
Keppler 16 tx
Keppler 20 nj

Now for this example I need to sum column B if A=Steeves and C=NY.

In this example it would return 25.

View Replies!   View Related
Double Inequations
Is it possible to enter double inequations? Excel returns "false" even it is obviously true. If I type =1<2<3 the result is "false".

I can get the correct result using =and(1<2,2<3), but that makes it longer, and if I have more formulas inside instead of numbers I'll have to repeat the middle one, it will take the place, but only in oreder to compare it again.

Is there anything that can be done with this?

View Replies!   View Related
Double Lookup For Name/Value
I have a list like this:

xxxxxxxxxx1-jan | 2-Jan | 3-Jan
Location 1
Bob Smith ----B2--- C2 ---- D2
Frank Thomas-B3---- C3---- D3
Location 2
Bill Clinton----ETC ALL
George Clinton

And another sheet, a similar list, (just names and randomly sorted) but populated with the values I want,

xxxxxxxxxxx1-jan | 2-Jan | 3-Jan
Bob Smith --- 2 -----5------ 1
Frank Thomas 3----- 1 ------2
Bill Clinton ----4----- 5 ------2
George Clinton 4----- 4 ----- 4

I want to check the name in A2 on the first sheet against all of column A on the second sheet, then find the number value for the correct day for that name.

How can I write a formula that will look up these values for me? I looked at OFFSET but unfortunately I don't have a lot of excel experience (yet)

View Replies!   View Related
Double Spacing
I have a list with fractions such as 25 1/4, 33 5/16, 20 15/16, etc. i have them formatted as FRACTIONS 2 DIGITS 21/25. Manny of those have double spacing ex: 25 1/2, So i am wondering if theres a way to take the extra spacing off the ones that have double.

View Replies!   View Related
Double Lookup
=INDEX('sqft - PC each bldg'!D2:D1705,MATCH(Sheet5!B3&Sheet5!F2,'sqft - PC each bldg'!A2:A1705&'sqft - PC each bldg'!C2:C1705,0))

my result is N/A

I wonder if it has to do with both lookup ranges being columns?

View Replies!   View Related
Double Loop
I am attempting to create some code that has 2 loops in it.


I will have 2 ranges (eg B54:B100, and B106:B149 - the problem is I will arrive at these ranges by code such as: Range(Selection, Selection.End(xlDown).End(xlDown)).Select)).


I need to have some code that will look through each cell in the second range and if the cell contents is found in the first range then the entire row from the second range will be deleted.

View Replies!   View Related
Double Condition, Or Else
Have a quick one, trying to figure out a simple expenses/income/saving tracking table for my wife and in-laws; have figured out most of it. Will use pivot to extract most of the data, but on a summary sheet I need double condition sums (or at least I guess so...). For example I have "amount" column (which is expanditure) and date column (have used function to extract month and year for other purposes to separate columns), how can I calculate multiple costs (all the costs/expenditures in a month) that have taken place in eg. april 2008 only/ since I want to display it on a separate sheet as a summary's the link to imageshack, dunno if it's gonna work:


Have tried something like: =SUMPRODUCT(month="4")+SUM(amount) but it sums up the entire column...

or this one: =SUMPRODUCT(ISNUMBER(MATCH(4,month,0)+SUM(amount)))
I know I miss a bunch on the last one

View Replies!   View Related
Double Dash In Formulas
I recently saw Krishnakumar use the formula.
= sumproduct(--(a2:a10=d2),--(b2:b10=e2),c2:c10)

I haven't seen sumproduct used this way. Very cool. I see how it is working, but can anyone tell me more about the syntax of the dash dash used in array 1 and array 2? I have never seen this. How is it different than =SUMPRODUCT(1*(A1:A9=G1),1*(B1:B9=H1),C1:C9), which is the syntax I'm used to seeing.

View Replies!   View Related
Open With Double-click
I seem to have broken something!. Whenever I double-click to open an Excel file (.xls files are associated correctly), Excel opens, but nothing happens. That status bar says "Ready," but my workbook never appears.

If I do a File-> Open within Excel, then I am able to open the workbook. I have no idea what is going on. This occurs for all Excel files whether they contain macros or not.

View Replies!   View Related
Macro To Run On Double Click
I have populated a listbox from a filtered list and when 'Double Clicking' a name I want a macro to run. All seems to be OK apart from it is not finding/returning any data; I know the data is there and I think it may be the way I'm referencing the listbox value;

Sub CopySignificant()

Dim DestSheet As Worksheet
Set DestSheet = Worksheets("Clients to Invoice")

Dim sRow As Long 'row index on source worksheet
Dim dRow As Long 'row index on destination worksheet
Dim sCount As Long
sCount = 0
dRow = 1...................

View Replies!   View Related
24 Hour Double Time
I have a timesheet which for certain days of the year calculates double-time. What i would like to do is have a formula that gives double time for a 24 hour period. I have a formula setup with a start time and end time for my double time, but it wont stop at midnight.

View Replies!   View Related
Double SUMIF Function
I was wondering if it is possible to have a double sumif. For example asssuming you have a table with three columns:
Col 1 (far left) is called Name
Col 2 (middle) is called date
Col 3 (far right) is called values

Now assuming that column 1 contains 4 different names, each repeated for each date in column 2. In turns the dates are repeated for each names (see below example)

Name Date
AAA Jul 06
AAA Aug 06
AAA Sep 06
BBB Jul 06
BBB Aug 06
BBB Sep 06
CCC Jul 06
CCC Aug 06
CCC Sep 06

Column 3 contains random values.

How can I sumif column 1 at the same time as column 2 (i.e. sumif for criteria AAA and Aug 06). Or if not possible is it possible to write a double Vlookup?

View Replies!   View Related
No Double Entries For Combobox
I have in "column A" an accountnumber and in "column D" a lastname.
The lastname can appear more than once and the accountnumber also.
Though I want combobox1 on userform1 to contain the lastnames.
It's possible to contain a double lastname as long as the accountnumber isn't the same.

For instance:
accountnumber: Lastname:
1234 Johnson
7890 Johnson

here Johnson will be insert twice into the combobox.

accountnumber: Lastname:
1234 Johnson
1234 Johnson

View Replies!   View Related
Double Click Range
I have a code for doubleclick on a cell and a gdt application chart will open.

Private Sub Worksheet_BeforeDoubleClicK(ByVal Target As Range, Cancel As Boolean)
Dim i As Integer
Dim gdt As Long
Dim S As String
Cancel = True
With Application

If Target.Address(False, False) "C11" Then Exit Sub

'Place your direct path to open this GDT application

S = "C:Documents and SettingsUserMy DocumentsAndy's MachineINSPECTIONGDTGDT BitmapGD&T_Font.exe"

If Dir(S) = "" Then
MsgBox "File does not exist:" & vbCrLf & S, vbCritical, "Error"
Exit Sub
End If
gdt = Shell("""" & S & """", vbNormalFocus)

End With

End Sub
What would the code be for a range of cells if doulbe clicked the range would be C11 thru C35

Also, I have a double click code for another symbol chart to open.

How, would this be used in the same manner if a coulmn or row were to apply on double click.

View Replies!   View Related
Stop Double Entries
I have a excel sheet with a macro set up. On the main sheet is all the information with expiry dates. Now each entry according to the expiry date goes into another sheet (Monthly Sheets) in the same document. However if you add to the main list and press go it re-sorts the list and duplicates are put into the monthly sheet. (Hope that makes Sense)

Here is the code from Naras for the sorting:

View Replies!   View Related
Double Click Event
I am trying to write some questions on cells of Sheet1 of a workbook. Then I want to write the answers on cells of Sheet2 of the same workbook. I want the user to be able to double click the question-cell on Sheet1 and be taken to the respective answer on Sheet2.

View Replies!   View Related
SUM Function And Double Click
I have a spreadsheet that just uses the basic "SUM" function. This morning I went to use it and the function does not work after I change a number within the field of that function. If, however, I go into the SUM function and double click, then hit enter, it does the new calculation.

View Replies!   View Related
Highlight On Double Click
here is what i am trying to accomplish:

on the worksheet there are six ranges...each range has three columns...the first is team name, the second is rep name, and the third is the metric being measured.

what i would like to happen is...

when a team name is double clicked in any one of the ranges, i would like all three cells (team name, rep name, and metric) to be boldfaced and have the cell interior change color for all instances across all six ranges that match the team name double clicked. when double clicked again, it should go back to original formatting.

likewise, when a rep name is double clicked in any one of the ranges, i would like all three cells (team name, rep name, and metric) to be boldfaced and have the cell interior change color for all instances across all six ranges that match the rep name double clicked. when double clicked again, it would go back to original format.

so for example, if i happen to click on a cell in the team column in the second range for "team a", all cells in each range (including the adjacent cells for rep and metric) would be highlighted.

View Replies!   View Related
Creat A Double Loop
I am trying to create a VBA code that will search through a column"A" and if it finds a calue that C1 then color it, when it finishes searching columnA then loop again and search for items that match C2

Here's what I have so far with no success

Sub ColorItems()
Dim i As Integer
Dim j As Integer
For i = 1 To Selection.CurrentRegion.Rows.Count
For j = 1 To ActiveCell.Offset(0, -2).CurrentRegion.Rows.Count
If ActiveCell.Offset(0, -1) = ActiveCell.Value Then
With ActiveCell.Offset(0, -2).Interior
.ColorIndex = 6
.Pattern = xlSolid
End With

View Replies!   View Related
Double Drop Down Validation
I have a spreadsheet with two drop downs, one lets say has country and the other city. When I select a country in the country drop down, I want to be able to only select cities in that country.

I used a method that I found in an earlier post, where I define the name of list of cities of a country to that country and then use the indirect function in city dropdown down validation. The prolem is I can still get mismatched city and country because when I change country, I still have the city from the previous selection untill I drop down and select the city again.

I would like the city to show blank when I change the country until I select a city from that country.

View Replies!   View Related
Double Lookup Values
I am trying to lookup the value that corresponds to three sets of data. The formula I have been using is but I am still getting #NA. Iíve attached the spreadsheet


I am looking to search Vendor name 1, Actual and A to return the value of 1.

View Replies!   View Related
Reverse Before Double Click
I am trying to create code so that when a cell in Column C (for example C1) is double clicked, it makes the font bold, italicized, blue and inserts a row below the double clicked cell. I am also trying to make it so that if the cell is double clicked again, it removes the bold, italics, blue and deletes the row that was previously inserted.

Private Sub Worksheet_BeforeDoubleClick _
(ByVal Target As Excel.Range, Cancel As Boolean)
If Target.Font.Bold Then
ActiveCell.Offset(1, 0).Rows("1:1").EntireRow.Select
Selection.Insert Shift:=xlDown
Cancel = True
If Not Target.Font.Bold Then
ActiveCell.Offset(1, 0).Rows("1:1").EntireRow.Select
Selection.Delete Shift:=xlUp
Cancel = True
End If
End If
End Sub

View Replies!   View Related
Int Function Only Works With Double
If you run the Int function on a product of two variables, it will return a different (wrong) result if the variables are both defined as single:

Sub roundingtest()
Dim a As single
Dim b As single
Dim cases As Integer
a = 18200
b = 0.01
cases = Int(a * b)
Debug.Print cases;
End Sub

this returns 181 instead of 182. If you define one of the variables as double, then it works fine. Is it just me?

Anyway, I found it to be quite useful, as i was trying to get a function to round to the first higher integer - as opposed to the first lower. so
182.1 -> 183
182.9 ->183
182 ->182

So weirdly enough, int(a*b)+1 does the trick! Of course if a or b is defined as a double, then it all goes to 182. So without any IFs, this works real nice!

View Replies!   View Related
Run Macro On Double Click
I want a X to be put in the activecell if empty or removed if already there. By searching this forum I found and read the article "Adding a Command Button to the Excel Right Click Pop-up Toolbar/Command Bar" and was able to add the code to do this to the right click sub menu. Is there a way to do the same thing by double clicking on the cell? This probably seems a bit nit pickey but I would just like for it to work using double click for my users. I wrote the following code to performe the action

Sub Toggle_Macro()
If IsEmpty(ActiveCell) = True Then
ActiveCell.Value = "X"
With Selection
.HorizontalAlignment = xlCenter
End With
With Selection.Font
.Name = "Arial"
.FontStyle = "Bold"
.Size = 12
.ColorIndex = 3
End With
Else: Selection.ClearContents
End If
End Sub

And placed the code below in Private Module of the Workbook Object.................

View Replies!   View Related
Double Click And Copy Data
I have a sheet with some 300 plus rows of data. I use filters to sort through the rows to get down to anywhere from 8 to 10 or so rows. At that point I would like to be able to select (doule click) a filtered row of 10 cells (A:J) copy the data and paste it to a different sheet starting with cell B18. I want to be able to perform this process up to 5 seperate times.

I have recorded a macro to do basically what I am trying but with many short falls. It only selects one row, I cannot double click on a row and it dosen't always paste to the proper cell.

View Replies!   View Related
Insert Double-comma At End Of String
i'm a complete excel novice, but i think this should be pretty easy for you guys...

i just bought a new satnav system after 4 years with tomtom...

anyway, to get the speed camera database to work with it, i must add a couple of commas at the end of each set of co-ordinates contained within the spreadsheet, like this:


thing is, most of them don't have the 2 commas at the end and just end with the number, like this:


therefore, what i need to do is make up a formula in excel to search for a double comma at the end of each set of co-ordinates and if it doesn't already have them, then it should insert them...

i'm guessing for anyone with excel experience, this should be pretty easy to solve...

View Replies!   View Related
Double Loop To Copy And Paste
i have this code

Dim UltFila As Long, i As Integer, k As Integer
UltFila = Range("A65536").End(xlUp).Row
k = 2
For i = UltFila To 2 Step -1
If Cells(i, 2) = 4102 Then
Range(Cells(i, 3), Cells(i + 15, 6)).Copy Sheets("Final").Cells(k, 1)
End If
If Cells(i, 2) = 4104 Then
Range(Cells(i, 3), Cells(i + 15, 6)).Copy Sheets("Final").Cells(k, 1)
End If ..................

View Replies!   View Related
Double Click Is Unlocking Worksheet
Testing my worksheet, I found that if I double click on any cell that is not locked, the worksheet becomes unprotected. I need to prevent this from happening. I tried the following code, but it didn't work.

View Replies!   View Related
Code To Simulate A Double Click
I'm trying to find the code which will have the effect of a double click.

I want to use event code so that when I click on a cell once it will cause a drop-down in the cell (the cell is formatted with wrapped text).

View Replies!   View Related
Looping Within Double Click Event
I would like to create a macro in which, when the user double clicks on a cell, that cell will be shaded yellow and other cells within the Workbook containing the same value as that cell will be crossed out. I have come up with the below code, but it doesn't work correctly. Any ideas on what I have done wrong? Would also like it to not cross out the cell the user double clicked on.

Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)

Dim wk As Worksheet
Dim selectedName As String
selectedName = ActiveCell.Value

With Selection.Interior
.ColorIndex = 6
.Pattern = xlSolid
End With

For Each wk In ActiveWorkbook.Worksheets

For i = 200 To 2 Step -1
If ActiveSheet.Cells(i, 2).Value = selectedName Then
ActiveSheet.Cells(i, 2).Font.Strikethrough = True
End If
End Sub

View Replies!   View Related
Double Post Find And Display
is there a function that will return the specific content of the cell. like for example, i have a cell that contains the word DOG(a1), and on the other one is a sentence like THEDOGBARK(b1)...the function must find the word dog and must put it in another cell(c1).

find (a1) to (b1) and display the word in (c1)...

a1 = dog
b1 = thedogbark

b1 = thedogbark

b1 = thedogbark

View Replies!   View Related
Screen Updating Double False
I have now seen a few codes, both from my instructor and on the web that is using code like this;

Application.ScreenUpdating = False

...... CODE HERE .....

Application.ScreenUpdating = False

Would there be any reason to this madness. Can't see why you wouldn't set it back to true and absolutly no reason to double false it?

View Replies!   View Related
Double Entry With Priority List
First post here and I hope to find a solution

I have 2 columns with data. The first one has 16000 data (6 digit numbers), which are 2 or 3 or 4 times the same (duplication). The second column has a list with name folders.

Question: How can I delete the duplicate/triplicate entries, and leave only the one I want, according to a priority list I have of name folders?

View Replies!   View Related
Why Does Pivot Table Double My Values When It Is Set To Sum
I can't figure it out it simply doubles the value the only thing i can think of is the totals in question that are related to subtotaled columns but is not subtotaled

View Replies!   View Related
How To Get A Userform By Double Clicking A Cell
how to get a userform by double clicking a cell.

I have created a userform, (my first one)-very simple form, i have created a massive textbox, so when i doubleclick a cell in Sheet 1, userform pops up and I can write comments.

I am not sure how to write a code for this? I know it will have Private Sub Doubleclick, not sure on the rest?

View Replies!   View Related
Double Click To Enter User ID
i have some code that allows my users to enter their user ID on double clicking. The worksheet code below shows how on double clicking into Colum 3 (If Target.Column = 3 Then) then the user ID will appear. Q: How do i get the code to work in Columns 3, 5 and 7 but not those inbetween?! I tried using "or" but it allowed the ID to be entered into all columns! i.e. 3,4,5,6 and 7 which is not what I require. In short I need the ID to appear on double clik into every other column.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

Dim user As String
'This refers to the function ReturnUserName, which takes the name from the NT environment

If Target.Column = 3 Then
Target = ReturnUserName
Cancel = True
End If

End Sub

View Replies!   View Related
Insert Call When They Have Double Number
I want to insert call when they have double number, See attached sample.

View Replies!   View Related
UserForm ListBox Being Double-loaded
I'm having problems loading data into a listbox. When the form first opens, it loads the data twice. I can then kill the form and restart it and the data is in there three times. I can't see any loading problems with the userForm_initialize routine. How can I ensure that the listBox is empty before I start adding data? This would also seem to be necessary prior to loading a different set of data into the form - correct?

View Replies!   View Related
IF Formula With Double Contents In A Column
the formula i used is " =IF(A2=A3;"YES";"NO")

the contents are as follows


2525 - YES
2525 - NO
2526 - YES
2526 - NO
2528 - NO
2530 - NO
2527 - YES
2527 - YES
2527 - NO

how can i use a formula... that tells the last double entry yes too instead no?
for example above...

2525 - YES
2525 - NO (i want the formula say this "YES" too..)

So i want to find out through filtering.. all the double entries with YES.. so i can work with it without missing any double entries.

View Replies!   View Related
Double Lookup From Two Dimensional Table
I am trying to get a cell in my spreadsheet to look up a value based on two values. I have a dropdown list that lists the worksheets in the workbook, and each worksheet has a table with width measurements for the columns and height measurements for the rows. I have a function that is mostly working, it calls the data from the proper worksheet, but it rounds the measurement values down, and I need it to round to the next highest value on the table.

For instance, the measurement may be 55" x 55" in, but the table has values for 54" and 60". The current formula rounds down to the 54" measurement, but I need it to round up to the 60". I have attached what I have so far with further notes and cells highlighted.

View Replies!   View Related
Disable Double Click Shortcut
When we double click between two cell it goes to the last entered cell. I would like to disable this through a macro. Can anyone pls provide me a code to disable this.

View Replies!   View Related
Double Click To Activate Message Box
Double Click to Activate Message Box
modify my code to do the following:

View Replies!   View Related
Double Condition (where Sumproduct Won't Work)
my table is something like below:

my program sheet looks something like this:

I need a double condition formula to check the date, if matches the date Column (A), and matches product Column (b), then returns Column (C) which is the doc#.
I Could easily do it if it is a sum product formula, but in this case, it is alpha numberic.

date: 14 Jun (dd / mm)
product -- Doc#
apple ---- ac21 (so what formula do I put here?)
Orange --- abc2 (formula?)

date --- product --- Doc#
12 Jun -- apple ----- abc1
12 Jun -- Orange --- ab12
14 JUn -- Apple ----- ab21
14 Jun -- Orange ---- abc2

View Replies!   View Related
Copyright © 2005-08, All rights reserved