0

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

Sheet one, vlookup results from serial number input

4
  • You have not explained your problem clearly at all. Maybe you're saying you want to enter a new row of the array used by VLOOKUP() when the returned results are #N/A? That means you would need dates, item numbers etc. for the new serial number. Where is that information going to come from? Aug 20, 2017 at 2:19
  • Please post a screen shot showing a mockup of what you'd like your worksheet to look like. You're going to have to use VBA to accomplish this. Aug 20, 2017 at 3:04
  • added pictures. I don t know how to explain it better
    – EZG07697
    Aug 20, 2017 at 3:24
  • 1
    Your edit mentions two images, but there is only one in your question.
    – Blackwood
    Aug 20, 2017 at 14:41

1 Answer 1

0

You cannot accomplish this on a excel sheet. You need to use VBA. Set up a form with the fields you want. I would put 3 buttons on the bottom. One Lookup which would populate the fields with the lookup info, one update to update the excel sheet. And one to close the form.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .