Have STAT files from several objects, I need to simpify my pick up values into an overview document LIST.
LIST file is where I want to be the main document and STAT file to a working document where to pick up values
Thx for any proposals.
I know that PIVOT can be good, but does not "fit" in my presentation.
I have the follow advice for you.
1) Don't work with merged cells in an excel file, you get in trouble with it sooner or later.
2) If there is no need to use differant workbooks, just work with 1 workbook.
At least use 1 workbook on the excelforum. It makes it a lot easier to understand for the forummembers. You can use differant worksheet in the workbook for that.
3) Also if you don't want to work with a pivot table, I think it is a lot easier to have the data verticaly instead of horizontally. (But this could be only my preference).
4) Think about the calculations first and after that (much later) take care for the format of the output.
Last edited by oeldere; 05-09-2020 at 01:04 PM. Reason: A changed in I
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
I do understand you, Of course it must be easy for you who assist have it easy.
I have done my homework.
Here comes a new file!
You right with merging. Have taken that away.
I learn a lot from reflections!
THX
Please try at
List B2
=iferror(VLOOKUP(B$2,'[KUNDSTAT ALFA.xlsx]Sheet1'!$B$12:$E$71,ROWS(B$3:B4),0),"")
or Sample I4
=iferror(VLOOKUP(I$2,$A$2:$C$17,ROWS(I$3:I4),0),"")
H2 =IFERROR(VLookup(H$2,$A$2:$C$17,2,0),"") and drag to the right.
H3 =IFERROR(VLookup(H$2,$A$2:$C$17,3,0),"") and drag to the right.
THX
to both of you!
THX
works brilliant
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks