Posted on 2013-06-27
Is it possible to change the results from a VLOOKUP in the same cell or would I need to create a new column? I have =VLOOKUP([Store '#],'Schedule'!$C$4:$HX$10000,183,FALSE) the results will return either BA or TT want to change BA to LM and TT to TR. Unable to change at the source. Tried a couple of different variations but keep getting #VALUE or #N/A.