Dear all,
I have a 2 database on different sheet on my workbook. How do I can look up/copy the data? I also attached the example
Please help, many thanks
Regards
Dear all,
I have a 2 database on different sheet on my workbook. How do I can look up/copy the data? I also attached the example
Please help, many thanks
Regards
Try this formula
Formula:Please Login or Register to view this content.
Thanks it works for one requirement but got #Value for other field (Green, expected result)
Can you help me with index match formula? because sometimes I move the result sheet and got N/A if I used Vlookup formula
Last edited by triaji; 10-23-2019 at 10:24 AM.
What do you mean by "move the result sheet"? Post a sample showing the problem....
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
Sometimes the result sheet, I moved to other my worksheet and it's got #value if I used vlookup formula. But not #value if use Match-Index Formula
Last edited by AliGW; 10-23-2019 at 10:46 AM. Reason: Please don't quote unnecessarily!
The sample sheet that I asked for did not attach. Please try again.
I already attached my question above, and I tried to explain to you that I prefer Index-Match formula than vlookup
And I asked you to post a sheet showing the problem... twice...
Here is an Index-Match version of the same. I have no idea what it will do if you "move your other worksheet".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks