Excel 2003 spreadsheet matching

[Closed]
Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hello,

I am trying, without much luck, to Match two values on seperate worksheets on excel 2003 so that values on one sheet will be matched and transferred from Sheet 2 to Sheet 1.

I have two worksheets with roughly the same info on both. On sheet 1 and 2 there is a reference number that should match. I need to match sheet 1's reference number to sheet 2's reference number so that when matched all other values on sheet 2 are brought accross to sheet one and matched accordingly with the correct reference number beside the info that is aready there, if no match is made then the result should be black. I have tried VLOOKUP formula's through other posts on this form here but with no sucsess.

If someone can please help it will be very mush appreciated.

Sheet 1--------------------------------------------- Sheet 2

A---------B-------C----------D--------------- A-------------B-----------C------------D
Name-------Ref------Info1----Info2----------Name---------Ref-----Info1----------Info 2
Smith------1234------xxx------xxxx ------- Jones---------4321---- xxxxx-------- xxxxx
Jones------4321----- xxxx------xxxx------- Smith-------1234------ xxxx -------- xxxxx

Thanks
Frustrated User.

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Vlookup works. There might be some error in the formula. please provide the formula you used and the location (ranges)...
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month