baggins22
03-10-2007, 03:01 PM
Hey everybody,
so im new to this forum, and new to VBA. This isnt really a VBA question, but has to do with excel non the less.
normally vlookup gets its value from the left most column of the table array by default. i need it to get the value from the right most column..
Example:
A ---------- B --------- C
1215 ----Type1------ Name
1353-----Type2------ Name2
From a different tab , i need vlookup to search for a name in column C and retrieve the value in column A
Any ideas?
so im new to this forum, and new to VBA. This isnt really a VBA question, but has to do with excel non the less.
normally vlookup gets its value from the left most column of the table array by default. i need it to get the value from the right most column..
Example:
A ---------- B --------- C
1215 ----Type1------ Name
1353-----Type2------ Name2
From a different tab , i need vlookup to search for a name in column C and retrieve the value in column A
Any ideas?