Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #108088

Re: IF statement with multiple VLOOKUPs

From Claus Busch <claus_busch@t-online.de>
Newsgroups microsoft.public.excel.programming
Subject Re: IF statement with multiple VLOOKUPs
Date 2015-10-09 18:46 +0200
Organization A noiseless patient Spider
Message-ID <mv8qtn$1lr$1@dont-email.me> (permalink)
References <8a7c7353-089e-43f9-a684-77ffb82dabe5@googlegroups.com> <mv8q9d$uub$1@dont-email.me>

Show all headers | View raw

Hi Dakota,

Am Fri, 9 Oct 2015 18:35:46 +0200 schrieb Claus Busch:

> =INDEX('Categories (2)'!A:E,1,MATCH(B2,INDEX('Categories (2)'!A:E,MIN(IF('Categories (2)'!A2:E100=B2,ROW(2:100))),0),0))

sorry, forgot to handle an error:

=IFERROR(INDEX('Categories (2)'!A:E,1,MATCH(B2,INDEX('Categories (2)'!A:E,MIN(IF('Categories (2)'!A2:E100=B2,ROW(2:100))),0),0)),"Not Found")
and enter the formula with CRTL+Shift+Enter


Regards
Claus B.
-- 
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

IF statement with multiple VLOOKUPs dakota park <coda281@gmail.com> - 2015-10-09 08:29 -0700
  Re: IF statement with multiple VLOOKUPs "Peter T" <askformy@gmail.com> - 2015-10-09 17:33 +0100
    Re: IF statement with multiple VLOOKUPs dakota park <coda281@gmail.com> - 2015-10-09 10:11 -0700
  Re: IF statement with multiple VLOOKUPs Claus Busch <claus_busch@t-online.de> - 2015-10-09 18:35 +0200
    Re: IF statement with multiple VLOOKUPs Claus Busch <claus_busch@t-online.de> - 2015-10-09 18:46 +0200
      Re: IF statement with multiple VLOOKUPs dakota park <coda281@gmail.com> - 2015-10-09 10:00 -0700
        Re: IF statement with multiple VLOOKUPs Claus Busch <claus_busch@t-online.de> - 2015-10-09 19:20 +0200
          Re: IF statement with multiple VLOOKUPs dakota park <coda281@gmail.com> - 2015-10-09 10:37 -0700
            Re: IF statement with multiple VLOOKUPs Claus Busch <claus_busch@t-online.de> - 2015-10-09 19:54 +0200
              Re: IF statement with multiple VLOOKUPs dakota park <coda281@gmail.com> - 2015-10-09 15:08 -0700

csiph-web