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

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

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 19:20 +0200
Organization A noiseless patient Spider
Message-ID <mv8ssl$a49$1@dont-email.me> (permalink)
References <8a7c7353-089e-43f9-a684-77ffb82dabe5@googlegroups.com> <mv8q9d$uub$1@dont-email.me> <mv8qtn$1lr$1@dont-email.me> <ac522721-a2be-4431-b410-78bae6562aeb@googlegroups.com>

Show all headers | View raw

Hi Dakota,

Am Fri, 9 Oct 2015 10:00:51 -0700 (PDT) schrieb dakota park:

> Awesome, this works! Just a couple of $ signs (sorry not sure what the excel terminology is still and it is perfect!

you are welcome.

Here is another solution. A little bit shorter and without
CTRL+Shift+Enter:

=IFERROR(INDEX('Categories (2)'!$A$1:$E$1,1,SUMPRODUCT(('Categories (2)'!$A$1:$E$200=B2)*COLUMN(A:E))),"Not Found")


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