Forum Discussion
Solved
Make List from every column that has data corresponding to name
Hi i have a problem figuring out how to make list like this From a table like this i need a formula that can list only the job person does i have tried "vlookup" and "hlookup" but no l...
For such layout
it could be
=LET( name, J4, personAmounts, XLOOKUP( name, jobs[Name],jobs[[bending]:[assembling]], ""), personJobs, FILTER( jobs[[#Headers],[bending]:[assembling]], personAmounts), IF( {1,0}, TRANSPOSE( personJobs ), TRANSPOSE( FILTER( personAmounts, personAmounts ) ) ) )if you are on Excel 365 or 2021
For such layout
it could be
=LET(
name, J4,
personAmounts, XLOOKUP( name, jobs[Name],jobs[[bending]:[assembling]], ""),
personJobs, FILTER( jobs[[#Headers],[bending]:[assembling]], personAmounts),
IF( {1,0}, TRANSPOSE( personJobs ), TRANSPOSE( FILTER( personAmounts, personAmounts ) ) ) )if you are on Excel 365 or 2021
- thankyou so much for this!
JohnHoego , you are welcome
- can you explain more about the IF({1,0}) parts? i've been trying to add a third column with a different value but it seems the value always the same for 1- infinity
