I have 3 columns of data. Column A has 900 items in it, Column B
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 |
I have 3 columns of data. Column A has 900 items in it, Column B
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 -- Regards Roger Govier "Lakewoodsale" wrote in message ... 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 |
All times are GMT +1. The time now is 07:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com