enter image description hereOK, so what I am trying to figure out is how I can make the vlookup result box, (if na), become a text box that updates the corresponding vlookup col_index_number.
to explain better, I have another sheet that is listed with serial numbers and all the purchase information (dates, item number,etc.). So when I enter my serial number it pulls all the data. Now what I would like to do is, that when the serial number has no information (new/unassigned) and the vlookup results are NA, i would like to simply add the information in the same "NA" boxes, so that it updates the serial number page.
image 1 shows my first sheet. and the second is the data base on screen two. I am currently using =VLOOKUP(C6,'Serial Numbers'!A5:F93,3,FALSE)
And I wanted to be able to enter the info on sheet one after the vlookup runs. all in the same boxes, so that I can actively update all the info from sheet one