LOOKUP in a range and return 4th column

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?