Hi ALL
I want to find and index data from sheet1 to sheet2 with 2 conditions fill over table
So now I post my data in the forum, please help me!
1. I take 2 condiontions: Messers and date
2. I want to have a table follow header of sheet2 from Sheet1
S/# (sheet2) into mă tắt (sheet1)
4;5;6;7;8;9;10 = 11;12;13;14;15;16;17
I attach file below:
http://www.mediafire.com/download/bg...SD-invoice.rar
Not all forummembers wants or are allowed to access external links.
You get better help is you add a small example of your excel file, without confidential information on this forum.
Please also add the expected result (manualy) in the file.
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.
If you MUST use an external link, please save as Excel file not as rar.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Oh, I did not before.
Ok, Now I post again my small data
please open it and solve puzzles in that data.
I am a little confused by your post. In the YELLOW cells in sheet 2, pleease write the column LETTER from Sheet1 that should be imported.
Thanks Glenn kennedyOriginally Posted by Glenn Kennedy
Your formula is very good. But when I apply in my original file. It did not work.
Maybe I don't understand your formula.
Can you explain for me =IFERROR(INDEX(tbl_GiathanhSX[8],SMALL(INDEX(((tbl_GiathanhSX[6]<>$B$5)+(tbl_GiathanhSX[3]<>$L$4))*10^10+ROW(tbl_GiathanhSX[6]),0),ROW(1:1))),"")
my mistake.
I did not understand Row(1:1) and *10^10.
Please explain it for me.
Probably the problem is here
tbl_GiathanhSX[8]
you should have selected the whole coumn. See also the PM that I have sent to you.
Very nice! Glenn.
I got it.
I think I use table so when I do it, I also take limit by table number, so it is reason. It did not work.
Thanks again.
It WILL work on Tables. The INDEX phrase should cover the whole column, the others, just the data rows. the 10^10 is used to make a large numerical difference between the matching rows and the non-matching rows, to make it easy for SMALL to return them in the correct order. Row(1:1) is just a counter to return the 1st, 2nd, 3rd matching results, etc.
if it is NOT working for you, please email it to me at the address on my PM to you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks