No announcements
Found 2924106 threads
-
0 VotesHow to use Named Range in Excel VLookup Formula
object. So you could use RefersToRange property to get the named range. Here is the example. Debug.Print ...Proposed | 3 Replies | 822 Views | Created by ThiyagarajanNarayanan - Friday, May 26, 2017 1:40 PM | Last reply by Chenchen Li - Monday, May 29, 2017 6:24 AM
-
1 Votes
ArrayFunction VLookUp with varibale input
information is saved in a two column dynamic range in excel named "RangeToLookIn". And again 1st columns contains product names and ...Answered | 2 Replies | 10005 Views | Created by asifhayat2ibf - Friday, November 19, 2010 6:13 PM | Last reply by asifhayat2ibf - Monday, November 22, 2010 11:37 AM -
0 Votes
vlookup Formula
explain vlookup formula in excelAnswered | 1 Replies | 2638 Views | Created by lakshmi kumari microsoft - Monday, September 2, 2013 6:23 AM | Last reply by George123345 - Tuesday, September 3, 2013 2:27 AM -
2 Votes
Excel 2007 VLOOKUP formula question
You can do everything in a macro. I think in this case it is better to use a formula in F6. run the macro below which will ...Answered | 5 Replies | 3161 Views | Created by chamdan - Friday, April 13, 2012 2:06 AM | Last reply by chamdan - Saturday, April 14, 2012 4:15 AM -
0 Votes
VLOOKUP range keeps changing
If you delete rows from the range A$1:$ZZ$9000, Excel will automatically adjust the range in the formula. If you don't want that, you could change the ...Unanswered | 1 Replies | 474 Views | Created by J-Bal - Monday, May 18, 2020 4:56 PM | Last reply by Hans Vogelaar MVP - Monday, May 18, 2020 7:26 PM -
4 Votes
How to user VLOOKUP to cross multiple excel sheets (formula)
Hello Cup: If you are going to use C# from Visual Studio, then we have some forum members that can help with that process. As far as the VLookup ...Answered | 9 Replies | 25116 Views | Created by CupOverTheTable - Saturday, July 28, 2012 8:27 AM | Last reply by CupOverTheTable - Friday, August 10, 2012 8:35 AM -
0 Votes
VSTO Excel: named range
Isabel, Take a look at the Sample that illustrates how to protect various controls on your Excel worksheet.Answered | 1 Replies | 5891 Views | Created by Isabel_v - Tuesday, May 16, 2006 7:21 PM | Last reply by Naveen Yajaman - MSFT - Wednesday, May 17, 2006 10:19 PM -
0 Votes
Excel Services Parameter/Named Range
available to see the named ranges that reference a single cell only. I have a named range that is a range of cells that I need to ...Answered | 1 Replies | 1575 Views | Created by MJC0813 - Wednesday, August 1, 2012 10:15 PM | Last reply by Asadulla Javed - Thursday, August 2, 2012 8:18 AM -
0 Votes
Import Data via SSIS, from an excel named range to master excel named range
I guess for named ranged you might need to use a .Net script - but other wise you can use the below SQL command in to fetch a set of rows/Columns ...Answered | 4 Replies | 7521 Views | Created by srituraj - Monday, May 7, 2012 3:38 AM | Last reply by RyanAB - Wednesday, November 12, 2014 2:59 AM -
0 Votes
Testing for a Named Range in Excel
Is there a macro in excel to see if a named range exists or not? I'm trying to delete a named range in ...Answered | 1 Replies | 4357 Views | Created by ElDorado - Friday, June 20, 2008 9:16 PM | Last reply by Navajo - Friday, June 20, 2008 11:23 PM -
0 Votes
Update VLOOKUP formula path
entire path with file name in a cell. Then refer to that cell I have the browse, select file and place file path in cell ...Unanswered | 1 Replies | 361 Views | Created by James N San - Tuesday, December 4, 2018 6:08 PM | Last reply by OssieMac - Wednesday, December 5, 2018 12:28 PM -
0 Votes
Access Seeing Named Range in Excel
'-->> need reference in a code module to Tools/References -- '-->> Microsoft ActiveX Data Objects (2.x) Library use mdac library ...Unanswered | 1 Replies | 864 Views | Created by iambasil - Sunday, November 3, 2013 4:07 AM | Last reply by Rich P123 - Monday, November 4, 2013 8:51 PM -
0 Votes
Create and Select Named Range in Excel
; "'!" & "Next_Ticket").Activate How do I create the named range so that it references a range instead of a value? ...Unanswered | 1 Replies | 353 Views | Created by thomasm516 - Wednesday, June 14, 2017 6:47 PM | Last reply by Peter Thornton (Excel MVP 2008-13) - Wednesday, June 14, 2017 7:47 PM -
0 Votes
how to formate vlookup in excel vba
Dear all, How to format date of cell vlookup in excel ...Unanswered | 3 Replies | 1662 Views | Created by cno_kh - Tuesday, June 4, 2013 1:55 PM | Last reply by Bernie Deitrick, Excel MVP 2000-2010 - Wednesday, June 5, 2013 3:47 PM -
1 Votes
How to separate data in Excel VLookup
vlookup formula in excel to separate data. thank you Answered | 3 Replies | 1986 Views | Created by Caulson - Friday, December 14, 2012 3:05 AM | Last reply by 许阳(无锡) - Monday, December 17, 2012 1:59 AM -
1 Votes
Named Range vs Range
Hi Oleg O, If you create a named range in code, and then only use it in code, then there are few benefits. Ed Ferrero ...Answered | 4 Replies | 2198 Views | Created by Oleg O - Tuesday, April 3, 2012 7:47 PM | Last reply by Ed Ferrero - Tuesday, April 10, 2012 1:12 AM -
0 Votes
display a named range of Excel cells in a RichTextBox
How would you display a named range of Excel cells in a RichTextBox in a Visual Basic program -
0 Votes
Loop Through Excel Named Range in C#
} But on the first line, how can I reference a named range : "myRange" in the worksheet which goes from b45 to c80?Answered | 2 Replies | 4263 Views | Created by Mark from NJ - Wednesday, February 25, 2009 6:10 AM | Last reply by Mark from NJ - Wednesday, February 25, 2009 2:56 PM -
0 Votes
Excel vlookup
I set up a vlookup function in a cell to pick up data from another spreadsheet. When does the lookup actually occur? The sheet is first loaded into Excel; someone ...Answered | 1 Replies | 899 Views | Created by Louis Yeung - Monday, April 14, 2014 10:29 PM | Last reply by George Hua - Wednesday, April 16, 2014 7:19 AM -
0 Votes
Cannot expand named range
Hi, I am trying to insert some records into an excel sheet thru Named range. I could have used the Sheet name but ... - Items 1 to 20 of 2924106 Next ›
No announcements
