LinkBack URL
About LinkBacks
Im learning how to do INDEX MATCH - I can get it to bring data back in one cell but when i drag down the formula it repeats the answer
I have attached an example.
Hope someone can help
Im learning how to do INDEX MATCH - I can get it to bring data back in one cell but when i drag down the formula it repeats the answer
I have attached an example.
Hope someone can help
Hi,
I don't think you need an INDEX/MATCH formula for what you are trying to do. In cell G2, you should tryand drag the formula down.Formula:
Please Login or Register to view this content.
Hope this helps
EDIT: Oh and the reason it is bringing down the same value every time is because the MATCH formula will return the FIRST occurrence of a match, which in the range "$E$2:$E$10" will always be row 3, thus "333" will be returned every time.
This isn't a case where INDEX/MATCH should be used,
Try In G2, drag/fill down
Formula:Please Login or Register to view this content.
[EDIT]
However as you are learning how to use INDEX/MATCH
Try this array formula in G2, Confirm with CTRL+SHIFT+ENTER before dragging down.
Formula:Please Login or Register to view this content.
This will work for 2007 and above.
Last edited by Marcol; 08-21-2013 at 07:54 PM.
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
That worked great!
Perfect!
Please don't forget to click on the * next to any post(s) that have been helpful to you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks