Help create a IF statement to look to to seperate vookup data sour

Can someone help me build a statement that will look to one vlookup table to
find data, and if no data exists, go to a second vlookup table to find the
data (data will always be present in this second table). Here are my 2
individual vlookup statements:

=VLOOKUP($F15,SHRINKS,6,false)

=VLOOKUP($F15,STORES_TY_PL,false)

I appreciate the help.

Will this work for you:

=IF(ISNA(VLOOKUP($F15,SHRINKS,6,false)),VLOOKUP($F15,STORES_TY_PL,false),VLOOKUP($F15,SHRINKS,6,false))

HTH,
Elkar


"Scottinphx" wrote:

> Can someone help me build a statement that will look to one vlookup table to
> find data, and if no data exists, go to a second vlookup table to find the
> data (data will always be present in this second table). Here are my 2
> individual vlookup statements:
>
> =VLOOKUP($F15,SHRINKS,6,false)
>
> =VLOOKUP($F15,STORES_TY_PL,false)
>
> I appreciate the help.

answers at your other post
--
paul
paul.shepherd@nospamparadise.net.nz
remove nospam for email addy!



"Scottinphx" wrote:

> Can someone help me build a statement that will look to one vlookup table to
> find data, and if no data exists, go to a second vlookup table to find the
> data (data will always be present in this second table). Here are my 2
> individual vlookup statements:
>
> =VLOOKUP($F15,SHRINKS,6,false)
>
> =VLOOKUP($F15,STORES_TY_PL,false)
>
> I appreciate the help.