| 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 | |||
Hybrid Mode
