Hello,
I have an index and match formula. The problem is that its picks up a cell twice instead of the different value. I have attached the workbook for you to have a review and come up with a solution.
I don't know if an array formula is the answer.Formula sheet.xlsx
Try this Array formula (Cntrl+Shift+Enter,not just Enter) in I6
Formula:
Please Login or Register to view this content.
Drag down
This takes a few seconds, at least on my(admittedly slow) machine, but if the column references (in red above) were made into ranges, instead of entire columns, the performance can be sped up immensely !
Hope this helps
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks