LOOKUP in a range and return 4th column

Maybe it is just me, but I am still a bit confused... I think you may need VBA for what you want... if that is you want to be able to instead of returning a value from the 4th column given a match in the 1st column, you want to actually input a value in that 4th column where there is a match in column 1?

Maybe posting a sample workbook with your request might help shed brighter light.

Originally Posted by NBVC

Maybe it is just me, but I am still a bit confused... I think you may need VBA for what you want... if that is you want to be able to instead of returning a value from the 4th column given a match in the 1st column, you want to actually input a value in that 4th column where there is a match in column 1?

Yes, this is exactly what I need... This if for a user form that is saving data to a range. Once I save the data, I need to do a VBA lookup in another range based on an ID field and update a column in that row!

g

Patch, please don't post the same questions in multiple Excel forums without linking to each. This is considered cross posting and, frankly, annoys the heck out of many people.

Link to cross post: http://www.mrexcel.com/forum/showthread.php?t=402921

Future posts may be locked for cross-posting without links.