I'm trying to pull some data from cells in another sheet but ignore some of it. I'm using this but its not working.

Formula: copy to clipboard
=IF('Import data'!BQ2="location",if('Import data'!BQ2="average",if('import data"!BQ2="combination")),"",'Import data'!BQ2)


If i just have one IF it works fine but nested is not working.

Also this formula simply returns a blank cell. Is there a way to have it skip the cell and not return anything?