afbutlerandassoc
MIS
here's my problem:
=INDEX(vendorrates,MATCH(A5,ratename),MATCH('Retail routing'!D3,[red]'LCR RATES'!D58:U58[/red],0)-1)
How can I look up the row and find the value if I don't specify which row to look for the value in (the red part)
This returns the right info, but it's not dynamic enough - I can't take the time to enter all the row array info for each lookup.
Thanks
=INDEX(vendorrates,MATCH(A5,ratename),MATCH('Retail routing'!D3,[red]'LCR RATES'!D58:U58[/red],0)-1)
How can I look up the row and find the value if I don't specify which row to look for the value in (the red part)
This returns the right info, but it's not dynamic enough - I can't take the time to enter all the row array info for each lookup.
Thanks