Trying to find a way to use VLOOKUP and Replace

[Cdubbe]

I have a vary large data sheet that I've been working on for a long time. I've made a handy table that uses vlookup to mine the data and return various information from the different columns. I also have it set up so that if a cell is empty it just shows a blank cell.

I've been looking around and trying to find if there was a way to edit the results of a vlookup inside of the small table I've made. For example if the drawing number for that part isn't listed, if I could input that data in a nearby box and have it actually edit the original cell in the table that the vlookup finds.

I didn't nkow if this could be done with a macro or a kind of replace function, but I'm hopeful. I have been able to find the address of the certain cell using a match function, so maybe there is a function that can write to a cell given it's adress?

Odd qustion and hope its not written too confusingly but any help would be a huge help, Thanks.

 

[Hamburgler]

I am not sure of exactly what your objective is. If you want to actually replace cell values – as opposed to having formulas return different values – then VBA is needed.

Otherwise interacting formulas using functions such as these may be useful.

ISNA, NOT, IF, AND, OR, ISNUMBER, SEARCH, OFFSET, &, COLUMN, ROW

Using named ranges/formulas might make it more manageable.

Sorry if I am on the wrong track. From the sound of it there is definitely a solution available. VBA is generally much more efficient, depending on your skill level.

 

[Cdubbe]

Yea, the objective would be to replace the cell values. I kind of figured it'd probably take some VBA work, but I really have little experience with it.

Still, thank you for the help, I'll keep digging in the VBA route

 

[Excelestial]

Almost anything can be done with a formula. Want to show an example? Looks like it's a mere matter of IF conditions.