Hello,
(formula in col F)
I had the following formula; (old formula)
=IFERROR(VLOOKUP($B3,$B$2:$F2,5,0),SWAPSHOP(B3,$B$3:$E$500,$I$3:$L$9)))
This formula would always return a value in Col F regardless of if Col E was blank or not.
I amended the formula to; (new formula)
=IF(E3="","",IFERROR(VLOOKUP($B3,$B$2:$F2,5,0),SWAPSHOP(B3,$B$3:$E$500,$I$3:$L$9)))
This now means that if Col E is blank then Col F also remains blank.
However this is not quite my desire.
I have a series of codes in Col B, sometimes they are identical. If Col C there will be a corresponding code description. If there is information in Col E then then formula is supposed to return a new code description - however now even if there is a value in E4 and E5 for material 100 because E3 is blank for code 100 the new code description does not update in Col F.
Please see attached for a visual of what I am trying to explain as I am struggling a fair bit to explain (I have knocked out all formulas and put this on a new spreadsheet to what I am really working on)
Bookmarks