Good afternoon!
I had a question on to write the vlookup formula for the below issue.
Show sheet 2 column 4 in sheet 1 column 4. I appreciate the help! Please see attached.
Good afternoon!
I had a question on to write the vlookup formula for the below issue.
Show sheet 2 column 4 in sheet 1 column 4. I appreciate the help! Please see attached.
Last edited by Guitarist; 05-04-2023 at 03:41 PM. Reason: Adding Workbook
with Power Query
Column 1 Column 2 Column 3 Column 4 1Smith, John Type Business 1 1Smith, John Type Business 2 1Smith, John Type Business 3 1Smith, John Type Business 4 1Smith, John Type Business 5 1Smith, John Type Business 6
![]()
// Join let Table1 = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], Idx1 = Table.AddIndexColumn(Table1, "Index", 1, 1), Table2 = Excel.CurrentWorkbook(){[Name="Table2"]}[Content], Idx2 = Table.AddIndexColumn(Table2, "Index", 1, 1), Join = Table.NestedJoin(Idx2,{"Index"},Idx1,{"Index"},"Table1",JoinKind.Inner), Exp = Table.ExpandTableColumn(Join, "Table1", {"Column 4"}, {"Column 4"}), RC = Table.RemoveColumns(Exp,{"Index"}) in RC
Last edited by sandy666; 05-04-2023 at 04:09 PM.
Put in D2 then copied down
=IFERROR(INDEX(Sheet2!$D$2:$D$8,AGGREGATE(15,6,(ROW(Sheet2!$D$2:$D$8)-MIN(ROW(Sheet2!$D$2:$D$8))+1)/(Sheet2!$B$2:$B$8=$B2),COUNTIF($B$2:B2,B2))),"")
Thank you all! Have a great day!!
You are welcome
if the problem is solved, make me happy and hit Add Reputation (bottom left corner next to the post that was helpful)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks