Hello,
so i ran into this problem using the INDEX + MATCH combination.
I pretty much have to look up the values (price), for each sock pair, from the
little table above. However, using either INDEX or VLOOKUP, returns only the first 4 values,
since all the others are duplicates. That being said, i need it to return every single one of them.
55555.PNG
How to get around this problem?
777777.PNG
Could you please post your workbook?
Please post a file (as many of us can't view PNG images) showing expected results.
Try these
=INDEX(B$6:B$9,MATCH(C13,A$6:A$9,0))
You need to lock the ranges of your formulae, so that the ranges searched remain the same as you copy the formula down.
for example:
=INDEX(B6:B9,MATCH(C13,A6:A9,0)) should be:
=INDEX($B$6:$B$9,MATCH(C13,$A$6:$A$9,0))
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
If i can figure out how to upload my workbook, then yes.
THANK YOU José Augusto and Glenn Kennedy!!
This did the trick!! Learn something new each and every day.
No problem. you're welcome and thanks for the Rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks