Menu
Menu
DaniWeb
Log In
Sign Up
Read
Contribute
Meet
Search
Search
About 94 results for
vlookup
- Page 1
vlookup modification in excel
Programming
Software Development
11 Years Ago
by masterjiraya
… has b and d only if I use this formula
Vlookup
($A:$A,$B:$B,1,FALSE), it returns b and… and f how would I do that. in discerete Mathematics,
vlookup
() is the INTERSECTION of 2 sets but what I want…;*"&$A:$A&"*" was used in
vlookup
)
Re: vlookup modification in excel
Programming
Software Development
11 Years Ago
by thines01
If Cell C1 contains the formula `=
VLOOKUP
($A3,$B$1:$B$6,1,FALSE)` then the result … IsError() to convert them to user-friendly values: `=IF(ISERROR(
VLOOKUP
($A1,$B$1:$B$6,1,FALSE)), $A1, ""…;)` ... `=IF(ISERROR(
VLOOKUP
($A2,$B$1:$B$6,1,FALSE)), $A2, ""…
vlookup to fetch data with more than one time occurance of name
Programming
Computer Science
11 Years Ago
by khushhappy
Dear all, Im getting a problem in Excel.
Vlookup
formula is working correct. Now the problem is when more than one time asc-1 comes in posting column, it do not show the 2nd name with asc-1. Formula for the
vlookup
is : =
VLOOKUP
(N15,A11:G87,2,FALSE) What will be the solution and how? Replyies will be appreciated.
Need additional Vlookup Help
Programming
Software Development
12 Years Ago
by Divinedar
… make a difference. I could probably use a horizontal
Vlookup
but I've never used one. The additional information…Row).Select Selection.FormulaR1C1 = _ "=IF(ISNA(
VLOOKUP
(RC[-6],SUMMARY2!C[-6]:C,7,0)),35…Row).Select Selection.FormulaR1C1 = _ "=IF(ISNA(
VLOOKUP
(RC[-8],SUMMARY2!C[-8]:C,9,0)),35…
EXCEL Vlookup Help please
Hardware and Software
Microsoft Windows
11 Years Ago
by masterjiraya
… has b and d only if I use this formula
Vlookup
($A:$A,$B:$B,1,FALSE), it returns b and… and f how would I do that. in discerete Mathematics,
vlookup
() is the INTERSECTION of 2 sets but what I want…;*"&$A:$A&"*" was used in
vlookup
)
Macro for "Sumif/Vlookup"
Programming
Software Development
15 Years Ago
by shahji
… different sheet in the same workbook. i normally use "
vlookup
" or "Sumif" or "Sumproduct" formulae… the data when i use "Sumif" or "
Vlookup
". i am looking for a macro which could replace…
MS EXCEL: How to find MAX value of a range using VLOOKUP?
Hardware and Software
Microsoft Windows
12 Years Ago
by quiptro
… two, ignoring all values in between: =MAX(
VLOOKUP
(A2,'Historical Data'!A4:O4385,2),
VLOOKUP
(AUDJPY!B2,'Historical Data'!A4:O4385,2…
Re: Loop until a blank cell and then use a vlookup
Programming
Software Development
8 Years Ago
by Taywin
…, you should take a look at [
VLOOKUP
()](https://support.office.com/en-us/article/
VLOOKUP
-function-0bbc8083-26fe-4963-8ab8-93a18ad188a1). The… must be the column you are looking for. i.e. `
VLOOKUP
("", A2:C7, 2, TRUE)`.
Re: Macro for "Sumif/Vlookup"
Programming
Software Development
15 Years Ago
by shahji
Hello everyone, I am posting a
Vlookup
Macro. thanks to Brian Baulsom. I hope this will help …
Incrementing using a vlookup
Hardware and Software
Microsoft Windows
12 Years Ago
by stevo7624
… of incrementing. I appreciate any help. Thanks, Steve =IFERROR(IF(
VLOOKUP
(B3,[3.10.12.xlsx]3.10.12'!$E$6…
Loop until a blank cell and then use a vlookup
Programming
Software Development
8 Years Ago
by devinem
How can you write a macros that will loop until it finds a blank cell. Then, once the first blank cell is found do a
vlookup
to a set of data? It will be looping on the same row.
Re: vlookup modification in excel
Programming
Software Development
11 Years Ago
by masterjiraya
I'm so very thankful to you Mr./Ms. thines01. from your formula posted above I have finally concluded that I in clude the NOT() before the IsError() so the results can only be seen in Line C. A very greatful help from you Mr./Ms. thines01. Now the discrete Mathematics' NOT INTERSECTION in the sets of data is now possible. I'm so surprised that …
Re: vlookup to fetch data with more than one time occurance of name
Programming
Computer Science
11 Years Ago
by khushhappy
Values are being shown on right side panel.
Re: EXCEL Vlookup Help please
Hardware and Software
Microsoft Windows
11 Years Ago
by Mike Askew
Could just be posted to the software development main forum, and tag it appropriately, as Daniweb is moving towards tagging.
Re: Macro for "Sumif/Vlookup"
Programming
Software Development
15 Years Ago
by cguan_77
you're looking for a specific value in sheet1 to pasted in sheet2? or you need to do calculation first in sheet1 and after doing the calculation you'll find for a specific result and copy over to sheet2? is it what you're trying to do or what?
Re: Macro for "Sumif/Vlookup"
Programming
Software Development
15 Years Ago
by shahji
well thank you for your reply, I would not have to calculate anything as all the values are already in the database. i would need to find a specific result and copy over to sheet2. i hope this helps, thanks, Shah
Re: Macro for "Sumif/Vlookup"
Programming
Software Development
15 Years Ago
by cguan_77
try this.. it will find a specific value..then copy the whole rows to sheet2.. just modify it to suit your needs.. hope it helps.. [code] Dim x as boolean Dim x1 as string x = Cells.Find(What:="Data to Find", After:=ActiveCell, LookIn:=xlValues, LookAt:= _ xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:= _…
Re: Macro for "Sumif/Vlookup"
Programming
Software Development
15 Years Ago
by shahji
thank you cguan, the code works fine. i was wondering if i could run a loop on this as the code stops after looking at the first value in sheet1 and copies it to sheet2. Also is it possible to give it more than one codition lets say it looks in sheet2 column1 for a value and copy a value from sheet1 column 3 corresponding to the value in …
Re: Macro for "Sumif/Vlookup"
Programming
Software Development
15 Years Ago
by cguan_77
yes it is possible to look for a value in sheet column1 and copy a value from sheet1 column3 but what you mean by "and a condition in sheet1 column2"?
Re: Macro for "Sumif/Vlookup"
Programming
Software Development
15 Years Ago
by shahji
thank for getting back to me, well i have attached a small example. sheet1 has three columns "Client", "Code" and "Balance" and sheet2 has two columns "Client"and "Balance". i want to copy data from Sheet1 "Balance" to Sheet2 "Balance". the data should correspond to …
Re: Macro for "Sumif/Vlookup"
Programming
Software Development
15 Years Ago
by cguan_77
hi shahji, try this, hope it helps... ;) [code] Sub Macro1() Dim x, y As Boolean Dim x1, x2, x3 As String Dim y1, y2, y3 As String 'declare the data to find y1 = "700" y2 = "0014" 'activate sheet1 and search Sheets("Sheet1").Select Columns("b:b").Select x = Selection.Find(What:=y1, …
Re: Macro for "Sumif/Vlookup"
Programming
Software Development
15 Years Ago
by shahji
hey Cguan, i have tried the above but it copies the macro to sheet2 rather than any data. any ideas why is that? thanks
Re: Macro for "Sumif/Vlookup"
Programming
Software Development
15 Years Ago
by cguan_77
try this.. :) [code] Sub Macro1() Dim x, y As Boolean Dim x1, x2, x3 As String Dim y1, y2 As String 'declare the data to find y1 = "700" y2 = "0014" 'activate sheet1 and search Sheets("Sheet1").Select Columns("b:b").Select x = Selection.Find(What:=y1, After:=ActiveCell, LookIn:=…
Re: Macro for "Sumif/Vlookup"
Programming
Software Development
15 Years Ago
by shahji
hey Cguan, thank you for the reply. the macro works but copies the entire row to sheet2. nearly there but not quite. two more things 1) if i need to look for a whole column instead of [B]y2 = "0014"[/B] for example y2 = A:A in sheet 2 2)I need to copy the value in Sheet1 Column C only not the entire row. thanks
Re: Macro for "Sumif/Vlookup"
Programming
Software Development
15 Years Ago
by cguan_77
[QUOTE=shahji;870671]hey Cguan, thank you for the reply. the macro works but copies the entire row to sheet2. nearly there but not quite. two more things 1) if i need to look for a whole column instead of [B]y2 = "0014"[/B] for example y2 = A:A in sheet 2 2)I need to copy the value in Sheet1 Column C only not the entire row. …
Re: Macro for "Sumif/Vlookup"
Programming
Software Development
15 Years Ago
by shahji
hey Cguan, thanks for getting back to me. after a long research i have found the following macro which copies data based on a condition and runs a loop as well. Sub CopyData() Dim lRow As Long, x As Long, y As Long, z As Long lRow = Sheets("sheet1").range("A65535").End(xlUp).Row…
Re: Macro for "Sumif/Vlookup"
Programming
Software Development
15 Years Ago
by cguan_77
try this: [code] Sub Macro2() Dim lRow As Long, x As Long, y As Long, z As Long, i As Long Dim xx(5) As String 'increase the array to any number you want lRow = Sheets("sheet1").Range("A65535").End(xlUp).Row y = 0 For x = 2 To lRow If Sheets("sheet1").Range("B" & x) = "700" And Sheets(&…
Re: Macro for "Sumif/Vlookup"
Programming
Software Development
15 Years Ago
by shahji
thanks man, we are nearly there. the macro works for one client but it does not pick the balances for remaining clients. lets say 0014 is the first client and 0027A is the 2nd client and 0027A2 is the third client. the macro stops at first client (0014) and pastes the value. i want it to keep looking in sheet2 column A and get the balances …
Re: Macro for "Sumif/Vlookup"
Programming
Software Development
15 Years Ago
by cguan_77
check my previous post..i implement the input box..then just put a loop.. like msgbox yes, no.. :)
Re: Macro for "Sumif/Vlookup"
Programming
Software Development
15 Years Ago
by ragsy.r
Hi Cguan, I have a similar request to build a macro for the spreadsheet to pull data from the master sheet with a few parameters in particular. If you can help me, I will send you the sample data. Looking forward for your reply. -Ragsy
1
2
3
Next
Last
Search
Search
Forum Categories
Hardware/Software
Recommended Topics
Programming
Recommended Topics
Digital Media
Recommended Topics
Community Center
Recommended Topics
Latest Content
Newest Topics
Latest Topics
Latest Posts
Latest Comments
Top Tags
Topics Feed
Social
Forums
Top Members
Meet People
Community Functions
DaniWeb Premium
Newsletter Archive
Markdown Syntax
Community Rules
Developer APIs
Connect API
Forum API Docs
Tools
SEO Backlink Checker
Legal
Terms of Service
Privacy Policy
FAQ
About Us
Advertise
Contact Us
© 2024 DaniWeb® LLC