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?
Bookmarks