Thread: Help create a IF statement to look to to seperate vookup data sour
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
paul paul is offline
external usenet poster
  
Posts: 247
Default Help create a IF statement to look to to seperate vookup data sour
answers at your other post
--
paul

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.
Reply With QuoteReply With Quote