This is what I need to do but I am not sure how to do it.
Cell A1 has a VLookup in it. Cell B1 is a manual entry Cell
Now here is what I want.
IN Cell on a new sheet Say Cell B5 for example I want to have this cell take the information from A1 if there is noting in Cell A1 from the original sheet . Please tell me how to right this formula.
Thank you
Stan
Cell A1 has a VLookup in it. Cell B1 is a manual entry Cell
Now here is what I want.
IN Cell on a new sheet Say Cell B5 for example I want to have this cell take the information from A1 if there is noting in Cell A1 from the original sheet . Please tell me how to right this formula.
Thank you
Stan