vlookup in one table if no data look in another

[Joe_Hunt via OfficeKB.com]

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.

 

[Joe_Hunt via OfficeKB.com]

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))

 

[Shane Devenshire]

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,))

 

[Joe_Hunt via OfficeKB.com]

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.

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.

 

[T. Valko]

You might be able to use this:

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

--
Biff
Microsoft Excel MVP

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.

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.