I have list of Expenses in Sheet2
Sheet1 contains the detailed expenses of each item
In Sheet3 in column B, When I select the list of expenses ( Already Done )
Then ( What I Want to Do is )
Column C should show only the expenses related to items selected in Column B, The list of Expenses is shown in Sheet1
I'm not sure what you want to do, but it's not Conditional Formatting.
The easiest option is to simply AutoFilter the main data
Display MoreI have list of Expenses in Sheet2
Sheet1 contains the detailed expenses of each item
In Sheet3 in column B, When I select the list of expenses ( Already Done )
Then ( What I Want to Do is )
Column C should show only the expenses related to items selected in Column B, The list of Expenses is shown in Sheet1
Have you tried Power Query? That might work for this.
Here is a UDF developed by Jindon that allows you to do Multi lookups
Option Explicit
Function VLookupMulti(ByVal strIndex As String, ByVal rng As Range, _
Optional ref As Integer = 1, Optional myJoin As String = " ", _
Optional myOrd As Boolean = True) As String
'
' jindon
' http://www.mrexcel.com/forum/showthread.php?t=344561&highlight=muvlookup
'
' =VLookUpMulti(A1, C1:D100, 2, ",", False)
'
Dim a, b(), i As Long, n As Long
a = rng.Value
ReDim b(1 To UBound(a, 1), 1 To 2)
With CreateObject("Scripting.Dictionary")
.CompareMode = vbTextCompare
For i = 1 To UBound(a, 1)
If a(i, 1) = strIndex Then
If Not .exists(a(i, ref)) Then
.Add a(i, 2), Nothing
n = n + 1: b(n, 1) = a(i, 2)
b(n, 2) = IIf(IsNumeric(a(i, 2)), a(i, 2), UCase(a(i, 2)))
End If
End If
Next
End With
VSortM b, 1, n, 2, False
For i = 1 To n
VLookupMulti = VLookupMulti & IIf(VLookupMulti = "", "", myJoin) & b(i, 1)
Next
End FunctionI have put the code into the attached
Don’t have an account yet? Register yourself now and be a part of our community!