minnesotauser wrote: > > I have two columns set up like so: > > a | 1 > b | 2 > c | 3 > > Is it possible to flip the way the columns are searched? > Thanks for any help. > =INDEX(A1:A3;MATCH(B4,B1:B3,0)) works with any pair of disjunkt vectors in ordered mode, unordered mode and there is an additional descending ordered mode (-1). In ascending ordered mode LOOKUP will do as well. The combination of INDEX and MATCH can substitute any use of V/H[LOOKUP].
-- View this message in context: http://nabble.documentfoundation.org/Problems-using-VLOOKUP-in-Libreoffice-Calc-tp3291389p3291447.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
