VLOOKUP in VBA

[vbabeginner111]

I have been trying to create a form and a log that work together (they are separate workbooks). So far, I have been successful in attaching a macro to radio buttons that will pull the 5 pieces of information I need from the form and input it into the log, however, each time you press one of these buttons, it creates a duplicate record in the log, just with a different end piece of information. To Clarify:

Pressing the "NO" button pulls the ID number, the part number, the date, and the purchase order from the form, inputs it into the log, and enters "NO" into the disposition column.

Pressing the "YES" button pulls the ID number, the part number, the date, and the purchase order from the form, inputs it into the log, and enters "YES" into the disposition column.

Pressing the "REJECTED" button pulls the ID number, the part number, the date, and the purchase order from the form, inputs it into the log, and enters "REJECTED" into the disposition column.

My issue with this is that I only want the second two buttons ("YES" and "REJECTED") to only adjust the disposition. I was trying to use VLOOKUP to have it find the ID number and then change the disposition, but I'm not sure how to do that across worksheets or to tell it to go several columns over and change a value once it finds the correct row.

Any help would be greatly appreciated.

[cytop]

A simple Find (in code) to search for the ID in a particular column of any worksheet. If found, you can simply refer to the cell offset x columns from that to update.

For example:

Please Login or Register  to view this content.

But for something tailored to your workbook, upload a sample copy.

[vbabeginner111]

So I'd be pulling the number to look for (the lookup_value?) from one work BOOK (a form) and searching for it in a DIFFERENT work BOOK (a log) and then changing the value there. This isn't sheet to sheet unfortunately.

The form has the ID number in cell M3. So I'd want the code to look something like this

Application.WorksheetFunction.VLOOKUP(M3[cell in form workbook],[range in log workbook A:E],2,FALSE)

And then change the value of the cell 3 columns over in the log.

I don't know how to tell the function to take the value from the form workbook and look for it in the log book, and then use the offset to change the value.

I'm very new to VBA and have only gone through a couple cursory courses on it. I hope some of this makes more sense.