query - search and find data in one sheet from another.

S

SS

I have two worksheets.

the first has 1 column of info that largely follows a trend of the data in
the coulumn incrementing by 1 as you go down.
the second has 2 coulumns. Most, but not all, the data in the first column
matches the data in column 1. Column 2 also has some data in it.

I want to populate the data in sheet one column 2 with the relevent data
from sheet 2 column 2 where there is a match with column 1.

how can I achieve this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top