LinkBack URL
About LinkBacks
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
Re: Vlookup to show different sub categories in the same category
with Power Query
Column 1 Column 2 Column 3 Column 4 Smith, John Type Business 1 Smith, John Type Business 2 Smith, John Type Business 3 Smith, John Type Business 4 Smith, John Type Business 5 Smith, John Type Business 6
Please Login or Register to view this content.
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)
Posting Permissions
Register To Reply
Bookmarks