Compare and update cells found with VLOOKUP?

Hello!

This is my first post on this forum, so hello everyone!

Im trying to create a workbook to track jobs my co-workers and I are working on. (i've attached what i have so far)

I used VLOOKUP to populate the fields in blue based on the number entered in the green field (there are a few test entries now, but there will be 500-1000 when in use)

What i would like to find a way to do is if the field returned with VLOOKUP is blank allow my users to enter information in the yellow fields and then have it update my sheet with the new entered data. If this somthing that can be done? Or is there another way i could go about doing this all together?

Any help would be greatly appriciated!

Thanks!

~Mark

Hey,

I added a button into your spreadsheet that will filter out anything you want.
This will bring up only the unique records in the database and allow you to edit them in place.
To reset the database just clear all of the search criteria and click the SEARCH button.

Let me know if this helps.


Simeon

Hi Mark,

Check this out for the search function. http://www.youtube.com/watch?v=Tr8Rwh8h1xM

Pretty darn cool actually, and I may end up using it on a project I have.