| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search for data in a column bring all related items in other colum | New Users to Excel | |||
| sum items in a column based on criteria located in other columns | Excel Discussion (Misc queries) | |||
| View only items in the left column that have X's in right columns | Excel Discussion (Misc queries) | |||
| 2 Columns - Show extra items in Column B | Excel Worksheet Functions | |||
| 2 Columns - Show extra items in Column B | Excel Discussion (Misc queries) | |||
Linear Mode
