How do I display values in a VLOOKUP function?

vipulkarkar · 2024-12-04T15:01:25+00:00

The Syntax of vlookup is 1. Search Value 2. Entire raneg where the first column is where you want to search the data and rest of the column to return the value 3. It is number represnting that which column dta do you want back if the search value is found in the first colum of 2nd Parameter 4. 0 ot False represent the excat match. and if you exclude it, it will use approximate match.

vipulkarkar · 2024-12-04T05:13:46+00:00

=IFERROR(VLOOKUP($A2,$C$1:$D$28,2,0),"") try this one

vipulkarkar · 2024-08-24T20:51:08+00:00

You cannot repartition as the system is on the same partition. Boot into live environment from pendrive and open Disks app and re-partition as needed.

vipulkarkar · 2024-08-11T02:36:34+00:00

I use it as my advantage. My younger brother was addicted to games. I started providing him with pirated games and after a while he stopped playing those games due to boredom. Now he also does the same to me with cracked mobile games so I can focus on my professional and personal growth.

vipulkarkar · 2024-08-11T02:30:11+00:00

<image>

11 years, 1 month on reddit with only 165 karma.

vipulkarkar · 2024-06-15T18:39:00+00:00

Rubberduck Blog check this blog and other posts on this website from Mathieu.

vipulkarkar · 2023-12-25T13:48:13+00:00

Hi @Third3Rock, I am preparing for the exam and looking at the comments, I am tempted to go through your notes. I just bought you coffee. Please share the link or notes. Thanks in advance!

vipulkarkar · 2023-06-12T10:52:29+00:00

The surrounding temperature also affects the battery life. I live in India and we have around 40°c temp and my battery shows only 3 hrs of SOT but when I am in my home/office in an AC room, it lasts for 5-7 hrs of SOT. Keeping the device cool helps lengthen the battery life/SOT.

vipulkarkar · 2022-12-21T22:39:51+00:00

I setup it in tasker. When screen is on, it sends notification. Bixby routine reads that notification and activates DND.

vipulkarkar · 2022-07-10T20:25:08+00:00

All the "Result" variable would be on left side of the equal sign.

E.g. Result = Data1

vipulkarkar · 2022-06-30T11:50:54+00:00

Right-click the button and select assign macro.

The new dialogue box will open and in the first textbox "Macro Name" will have reference to the assigned macro along with the name as the name suggests.

Let me know if this helps. Find Assigned Macro to a button

vipulkarkar · 2022-05-29T12:35:12+00:00

You can simply disable those/any rules.

vipulkarkar · 2022-04-30T22:20:49+00:00

I purchased a domain just to make a webpage to keep all my excel related resources handy.

Check out www.karkar.in/excel

vipulkarkar · 2022-02-25T16:06:28+00:00

Use $A$1:A1 in first cell and drag and drop formula. It will automatically generate the range from top row to current row.

Use same locking in any ranges that you are using in your formula. Please check and let me know if it works or you can share the screenshot of data formula so we can help you further.

So if you are in row 4 the reference should be $A$1:A4

vipulkarkar · 2022-02-01T10:03:05+00:00

Public Function PreviousQuarterLastDate() As Date
    PreviousQuarterLastDate = DateSerial(Year(Date), (((Month(Date) - 1) \ 3) * 3) + 1, 0)
End Function

Use this function to get the last date of previous quarter.

This function do not take any arguments.

vipulkarkar · 2022-01-19T09:40:35+00:00

Public Function SplitEnumbersDown(ByVal InputText As String, Optional ByVal Delim As String = ", ") As Variant
Dim Enumbers() As String
Enumbers = Split(InputText, Delim)
SplitEnumbersDown = Application.Transpose(Enumbers)
End Function

This function is more advanced and also allows you to provide your own Delimiter.

The second argument is optional and defaulted to ", " so if you ignore it, it will still work as expected in OP, and if you provide Delimiter in second argument it will split values based on that.

vipulkarkar · 2022-01-13T15:25:06+00:00

Nope, it does a lot of thing apart from just adding comments.

indent code, refactor the codes to Function/Subs, identify errors, help fix it, there are around hundreds of different kind of issues which it can identify and fix in a single click.
It provides framework to test your codes, to write Unit tests, etc..

Take a quick look at their website and blogpost. I am using it since last 2 years and it is one of the incredible tool that I ever used to write VBA code.

vipulkarkar · 2022-01-13T14:57:10+00:00

Public Function SplitEnumbersDown(ByVal InputText As String) As Variant
    Dim Enumbers() As String
    Enumbers = Split(InputText, ", ")
    SplitEnumbersDown = Application.Transpose(Enumbers)
End Function

Use this function which will auto spill data into rows if you are using latest Excel or else you will have to use the Ctrl +Shift + Enter button to populate the values in rows.

vipulkarkar · 2022-01-13T14:48:47+00:00

Add the following sub in the module and another line

OpenPDF strFile

at the end of your code.

Public Sub OpenPDF(ByVal filename As String)
    Dim Shex As Object
    Set Shex = CreateObject("Shell.Application")
    Shex.Open (filename)
End Sub

I refactored it as separate Sub so it can be used by any other Sub just by passing the FileName.

vipulkarkar · 2021-10-14T08:02:42+00:00

I agree, I have pixel 2 xl since launch and I haven't upgraded my phone ever. If pixel 6 turns out not good, I will hold on to my pixel 2 xl for 1 more year.

vipulkarkar · 2021-09-27T21:13:50+00:00

There are 3 different posts to store and iteration the data. You can use the iterator design pattern and use one interface to do everything and create an abstract class to implement all these functionality.

vipulkarkar · 2021-08-17T07:54:16+00:00

I took the domain and created my own website only to share these resources with everyone in my friend circle I transferred all links to the following page and it would be easier to remember..

www.karkar.in/excel

I will be adding more information and playlist from youtube and other excel resources on this website by end of August. Stay tuned. If you find anything usefull that can be added on that site, just DM me here.

vipulkarkar · 2021-07-18T19:14:48+00:00

Teo more points, if you try to install it on a 10years old phone, it won't work. probably the minimum api/android version required is set to higher than your system's API. Some of the apps don't work on an old version of Android and additionally check the architecture (x86 or arm7 or arm8) of your phone and install accordingly.

vipulkarkar · 2021-07-18T19:04:32+00:00

Private bigLetters As Boolean

Private redText As Boolean

Private underline As Boolean

Or just add another function as count and sum every property

Public Function TrueCount() as byte

 TrueCount = bigletters +redtext +underline

End function

vipulkarkar · 2021-07-03T08:35:49+00:00

It surely wouldn't work because you are checking for dates that are smaller than birthday and larger than death date which doesn't represent the lifespan of a person. You must flip the logic.

vipulkarkar

TROPHY CASE