I have 3 columns of data. Column A has 900 items in it, Column B

L

Lakewoodsale

I have 3 columns of data. Column A has 900 items in it, Column B contains
65000 items in it. Column A numbers are located somewhere in Column B.
Column B is linked to Column C, which is the retail pricing of Column B. I
have sorted Column A and B in ascending order. How do I find column A's data
in Column B's data and return the Column C's retail pricing to Column D.
Thanks
 
R

Roger Govier

Hi

I assume that column A items only occur once in Column B.

In D1
=VLOOKUP(A1,B:C,2,0)
Copy down through D2:D900
 

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

Similar Threads

Sum Column C for duplicate account number in Column A 8
Split column contents (de-concantenate) 7
Sort/Reference formula help needed. 7
Sort/Reference formula help needed. 1
select a range in a column 4
compare data in column A with column B to find duplicates 8
Renaming Data... 2
Comparison of columns and calculate differences 1

Top