LOOKUP in a range and return 4th column

**Patchworks** · 07-15-2009, 01:32 PM

I have a value that I need to look up in Named Range!

For example if the named Range is "Test" and the first field is an ID field and I have the Value of "01".

How would I do lookup and return the value in the 4th column of the named range?

g

Actually, I didn't think of this before, but I'm actually want to LOOKUP and change the value in Column 4. Can this be combined into 1 line of code?

**NBVC** · 07-15-2009, 01:37 PM

=Vlookup(X1,Test,4,False)

where X1 contains the value to look up in the first column of Test.

**Palmetto** · 07-15-2009, 01:37 PM

Assuming you are using the VLOOKUP function:

the third argument specifies which column to look in, thus

vlookup(MyCell,MyDynamicRange,4,False)

If you're using another look up method, such as INDEX/MATCH, let us know because the explanation is different.

**Patchworks** · 07-15-2009, 02:41 PM

Thanks guys!! That helped alot!

Can one of you provide me with an example of how to update the 4th column in that row where the lookup is found?

g

**NBVC** · 07-15-2009, 02:43 PM

Not sure what you mean?

**Patchworks** · 07-15-2009, 03:35 PM

Originally Posted by NBVC

Not sure what you mean?

Basically, I want to look up a value which is in the first column of a range and update a value in the 4th column of that row!

Does that make sense?

g

**NBVC** · 07-15-2009, 03:39 PM

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.

**Patchworks** · 07-15-2009, 09:54 PM

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

**Paul** · 07-15-2009, 10:48 PM

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.