Hello,

First time poster here with an issue.

Currently I have an workbook set up with 3 tabs to it.

In the first tab I have all the player IDs from Fangraphs.com that I downloaded from them. The name of the player is in Column 1 and the ID is in column 2.

In the second tab I have imported all the information for this website: http://espn.go.com/mlb/stats/batting...ookie/minpa/50

In column T:T I have it set to index(match( their name from Tab 1 and return the ID of the player. In Column U:U I have the formula:
="http://www.fangraphs.com/statss.aspx?playerid="&T3

This all is working fine for me and I can call the data as needed and import each URL just fine on tab 3.

Tab 3 is where I am running into issues!

Here is the formula's I am currently using:

Major League Flag ESPN ID Player Name Import
1 =INDEX('ESPN'!B:B,MATCH(B3,'ESPN'!A:A,0))
=IF($D3="",B2+1,B2) =IF(D2="Total",INDEX('ESPN'!B:B,MATCH(B3,'ESPN'!A:A,0)),"") =IMPORTHTML(INDEX('ESPN'!$U:$U,MATCH($B3,'ESPN'!$A:$A,0)),"table",0)

The X's are just for show at the moment. I am going to later indicate which year the player hit the minors.

The issue I am running into is in C3.

I can't just copy down row and say if the column above is blank then do this statement because the IMPORTHTML won't overwrite a cell with text in it. Is there a way I can get the cell B3 to run a statement in C3 so it has enough space for it to run and not over write data?

If you need to visually see it further just let me know your email address and I can share the doc with you through Google Sheets.