Importing spreadsheet with help of if statements

[xnolen]

Is it possible to import a spreadsheet with an if statement?.
Example:
I need to import a spreadsheet from a list if I select a certain category.
If Cell A2 = any from the following list, Project, Open, Closed, All. I need it to import that list spreadsheet.
I know i can nest if statements in excel but can not figure out how to import a whole spreadsheet if one of these is selected.
Please if you know anything that can help me pleas let me know if this is possible, is there any if elseif statements I can use that could help me simplify my if statements as well? if its not possible let me know also. If not I will have to find a different way to go about this.
Thanks

 

[Special-K99]

An IF formula cannot import spreadsheets. It's just a formula that produces a result, either string or numerical. It can't open files.
Use VBA to import files.

Sounds like you need a VBA macro to open a file depending on what value you put in A2.

 

[Richard U]

I agree, you need some vba code. The good news is that it's easy to write. It would look something like....

Function MyFunction(MyCellValue)

select case MyCellValue

case "Project", "Open", "Closed", "All"
     'do something'
case else

end select
end function