Morning everyone,
I am having an issue with an index formula not working. Im pretty sure i have entered it right but its not pulling information from the other sheet. I have attached the workbook for you to see, maybe some on has some insight for me.
Thanks for your help.
you should be matching in d not e
=INDEX(Sheet2!$A$2:$G$3000,MATCH($A11,Sheet2!$D$2:$D$3000,0),MATCH($B$7,Sheet2!$A$1:$G$1,0))
in fact you are not doing that in the second one either the first match giving the row number must ref col D sheet 2 as thats where the invoice numbers are
Last edited by martindwilson; 02-05-2010 at 10:57 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Are you kiddin me,,, i stared at that thing forever looking for what i did wrong. I was a really late night last night. Thanks alot
Ok well what about the other index in the tracking column?
same thing applies col a values can only be found in col d sheet2
I see it now ,,,the match names were not the same, i had to change the match name on sheet 2. Thanks again Martin, I assume
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks