Find matching values in two different columns
You're welcome. Thanks for the feedback!
--
Biff
Microsoft Excel MVP
"lmarstin" wrote in message
...
Thank you very much, worked great
"T. Valko" wrote:
Column 1 = A1:A10
Columns 2 and 3 = J1:K10
Try something like this:
=VLOOKUP(A1,J$1:K$10,2,0)
Copy down as needed.
--
Biff
Microsoft Excel MVP
"lmarstin" wrote in message
...
I have 3 columns. I need to take the value in column 1 and locate the
matching value in column 2 and then write the corresponding value in
column 3
to a new column.
|