Need some help comparing rows from 2 tables [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,

i have 2 tables... table 1 has sequential serial #s (a) and corresponding prices (b). table 2 has the same serial numbers (a) (used multiple times in random order). i want to put the corresponding price for each serial number from table 1 into a blank row (B) in table 2 for each row so the end result is table 3.
.
table 1 is constant and a lot shorter then table 2. i have many different "table 2s" throughout the year
.
table 1......................................table 2..................................table 3 - .....this is the result
A.......B ...................................A.........B................................A........B......i want from the
1.......5.99.................................4..........................................4........4.35.... two tables
2.......7.00.................................1..........................................1........5.99
3.......8.96.................................2..........................................2 ...... 7.00
4.......4.35.................................5..........................................5........5.45
5.......5.45.................................5 .........................................5 .......34.75
7.......15.99...............................3..........................................3....... 8.96
8.......2.50.................................9..........................................9 .......13.00
9.......13.00...............................4..........................................4 ......4.35


any help would be greatly appreciated. this is for my job and im expected to figure out a way to get it done.


2 replies

Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
118
Hi Joey,

if is difficult to understand which program are you using. whether it is MsWord or MsExcel.

If you are using MsWord than you have to do it manually.

and if you are using MsExcel you can do it by using VLOOKUP, but you are have to specify either both table in same sheet or you are refering sheets as tables?


Regards!
Rahul
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
797
therfe is no need for table 3. keep table 3 as chcek

I presume all the tables are in the same sheet

see the file joey.xls download it from

http://speedy.sh/Gmfng/joley.xls

see the formula in E1 which is copied down.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!