I need help with Lookup (vector).
Lookup seems to have the function I need. But my lookup_vector and result_vector are not the same size. So I guess I can not really use the lookup function. Please help.
Here is my problem. I have two worksheets. The first worksheet has columns A, B, C, D, the second worksheet has columns A', E, F, G. The column A' has more rows than A, and all the values in A are in A'. I need to bring the values in the columns E, F and G in the second worksheet into the first worksheet when A matches A'.
Please advice and let me know if my description is not clear.
Fred
Lookup seems to have the function I need. But my lookup_vector and result_vector are not the same size. So I guess I can not really use the lookup function. Please help.
Here is my problem. I have two worksheets. The first worksheet has columns A, B, C, D, the second worksheet has columns A', E, F, G. The column A' has more rows than A, and all the values in A are in A'. I need to bring the values in the columns E, F and G in the second worksheet into the first worksheet when A matches A'.
Please advice and let me know if my description is not clear.
Fred