Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help create a IF statement to look to to seperate vookup data sour
Will this work for you:
=IF(ISNA(VLOOKUP($F15,SHRINKS,6,false)),VLOOKUP($F 15,STORES_TY_PL,false),VLOOKUP($F15,SHRINKS,6,fals e)) 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help create a IF statement to look to to seperate vookup data sour
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
How do I create a link between columns from a data chart? | Excel Discussion (Misc queries) | |||
Displaying data from seperate sheet upon drop down box entry | Excel Worksheet Functions | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Reference multiple cells in if statement | Excel Worksheet Functions |