excel - IF statement that will let me input values from a single cell -
i need through column c , search text "tf06" , if that's true need replace corresponding row in column d specific input cell f2.
this far can get. here code:
=if((vlookup("tf06", c2:d54, 2, false)), replace(rows(vlookup("tf06", c2:d54, 2, false)), 1, 1, f2), 0)
this should work...if f2 change f$2 should in column d if thats want data go?
=if(a3="tf06",f3,"")
Comments
Post a Comment