in need of altering formula from previous thread

[RachelMads02]

Hello everyone,

I had a thread made a few weeks ago, linked here: http://www.excelforum.com/excel-gene...us-thread.html

JeteMC provided the formula for me, but i have a question in regards to the values returned. Looking at the attached document below the sheets in question are "UPGRADES" & "CPU". When placing the letter "U" in any cell within the upgrades column of the "CPU" sheet certain cells return their respective values into the cpu section of sheet "UPGRADES" within cells G3:N5.

When looking at the sheet titled "UPGRADES" the cells in question are the highlighted cells I4 & I5. This is the "name" column and it returns a value of 0 when the "CPU" sheet does not have text in the names column. What i want is the cells I4 & I5 to remain blank when a name is not contained in the CPU sheet rather than a 0 value.

What must i change for this to happen? I will have to adjust all the cells with this formula in them so i need the adjustment to be universal. Basically: Return the value in the respected cell or remain empty.

Thanks Guys!!

[CAntosh]

The most straightforward fix is to add an IF clause for blanks. Paste the following in UPGRADES!I3 and fill down:

=IFERROR(IF(INDEX(CPU!D:D,MATCH(ROWS($1:1),CPU!$H:$H,0))="","",INDEX(CPU!D:D,MATCH(ROWS($1:1),CPU!$H:$H,0))),"")

[RachelMads02]

thank you, that works