vlookup in one table if no data look in another
 

I have a rather large workbook with dozens of pages and I'm having trouble
with a vlookup that I would appreciate help with. What I need is for one
table (with 2009 data) to be looked at and if there's no value then to look
at another table (with 2008 data). The formula I came up with, that doesn't
work if there's no 2009 data, is:

=IF(VLOOKUP($B$94,ALG09Data,4,FALSE),VLOOKUP($B$94 ,ALG08Data,4,FALSE),VLOOKUP
($B$94,ALG09Data,4,FALSE))

B94 has the value I'm looking for. I would appreciate any help.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200812/1

vlookup in one table if no data look in another
 

Oops. the formula I meant to put was:

=IF(VLOOKUP($B$94,ALG09Data,4,FALSE)0,VLOOKUP($B$ 94,ALG09Data,4,FALSE),
VLOOKUP
($B$94,ALG08Data,4,FALSE))

Joe_Hunt wrote:
I have a rather large workbook with dozens of pages and I'm having trouble
with a vlookup that I would appreciate help with. What I need is for one
table (with 2009 data) to be looked at and if there's no value then to look
at another table (with 2008 data). The formula I came up with, that doesn't
work if there's no 2009 data, is:

=IF(VLOOKUP($B$94,ALG09Data,4,FALSE),VLOOKUP($B$9 4,ALG08Data,4,FALSE),VLOOKUP
($B$94,ALG09Data,4,FALSE))

B94 has the value I'm looking for. I would appreciate any help.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200812/1

vlookup in one table if no data look in another
 

Hi,

Try


=IF(ISNA(VLOOKUP($B$94,ALG09Data,4,)),VLOOKUP($B$9 4,ALG09Data,4,),VLOOKUP($B$94,ALG08Data,4,))

In 2007

=IFERROR(VLOOKUP($B$94,ALG09Data,4,),VLOOKUP($B$94 ,ALG08Data,4,))

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Joe_Hunt via OfficeKB.com" wrote:

I have a rather large workbook with dozens of pages and I'm having trouble
with a vlookup that I would appreciate help with. What I need is for one
table (with 2009 data) to be looked at and if there's no value then to look
at another table (with 2008 data). The formula I came up with, that doesn't
work if there's no 2009 data, is:

=IF(VLOOKUP($B$94,ALG09Data,4,FALSE),VLOOKUP($B$94 ,ALG08Data,4,FALSE),VLOOKUP
($B$94,ALG09Data,4,FALSE))

B94 has the value I'm looking for. I would appreciate any help.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200812/1

vlookup in one table if no data look in another
 

That didn't quite work, but it cleared it up for me enough to see it. For the
record in case it helps anyone else this works:

=IF(ISNA(VLOOKUP($B$94,ALG09Data,4,FALSE)),VLOOKUP ($B$94,ALG08Data,4,FALSE),
VLOOKUP($B$94,ALG09Data,4,FALSE))

Thank you very much! You've saved me a ton of work.

Shane Devenshire wrote:
Hi,

Try


=IF(ISNA(VLOOKUP($B$94,ALG09Data,4,)),VLOOKUP($B$ 94,ALG09Data,4,),VLOOKUP($B$94,ALG08Data,4,))

In 2007

=IFERROR(VLOOKUP($B$94,ALG09Data,4,),VLOOKUP($B$9 4,ALG08Data,4,))

I have a rather large workbook with dozens of pages and I'm having trouble
with a vlookup that I would appreciate help with. What I need is for one
[quoted text clipped - 6 lines]

B94 has the value I'm looking for. I would appreciate any help.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200812/1

vlookup in one table if no data look in another
 

You might be able to use this:

=VLOOKUP($B$94,IF(COUNTIF(INDEX(ALG08Data,,1),$B$9 4),ALG08Data,ALG09Data),4,0)

--
Biff
Microsoft Excel MVP


"Joe_Hunt via OfficeKB.com" <u45578@uwe wrote in message
news:8f7161ef2e5cc@uwe...
That didn't quite work, but it cleared it up for me enough to see it. For
the
record in case it helps anyone else this works:

=IF(ISNA(VLOOKUP($B$94,ALG09Data,4,FALSE)),VLOOKUP ($B$94,ALG08Data,4,FALSE),
VLOOKUP($B$94,ALG09Data,4,FALSE))

Thank you very much! You've saved me a ton of work.

Shane Devenshire wrote:
Hi,

Try


=IF(ISNA(VLOOKUP($B$94,ALG09Data,4,)),VLOOKUP($B $94,ALG09Data,4,),VLOOKUP($B$94,ALG08Data,4,))

In 2007

=IFERROR(VLOOKUP($B$94,ALG09Data,4,),VLOOKUP($B$ 94,ALG08Data,4,))

I have a rather large workbook with dozens of pages and I'm having
trouble
with a vlookup that I would appreciate help with. What I need is for one
[quoted text clipped - 6 lines]

B94 has the value I'm looking for. I would appreciate any help.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200812/1