Thread: vlookup in one table if no data look in another
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe_Hunt via OfficeKB.com Joe_Hunt via OfficeKB.com is offline
external usenet poster
  
Posts: 50
Default 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

Reply With QuoteReply With Quote