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

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

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

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

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