LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 1
Default comparing sheet to sheet and adding value

Alright,
I can't find a formula i could use to do this and was hoping for some help.

I have a workbook with 2 sheets.
I need a formula that will compare column a from sheet 1 with column a from sheet two. If there is a value that matches, i need it to put value out of that same row in sheet two and put it on column b in sheet 1 for that particular value.

The info is confidential so i can't upload here i hope what i ask for makes sense though.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding New Sheet, But Carrying Over Previous Sheet's Cell Calls Kai[_5_] Excel Programming 2 October 29th 11 05:16 AM
comparing two excel sheet and providing the outcome in a 3rd sheet jyoti prakash[_2_] Excel Programming 1 May 19th 08 09:41 PM
Adding a new Sheet but not making it the Active Sheet David Excel Programming 4 October 17th 07 02:11 PM
VBA to stop XL from adding the Path Sring to Sheet-to-Sheet Links [email protected] Excel Discussion (Misc queries) 5 August 18th 06 01:46 PM
adding data from one sheet to another sheet as a dropdown list bo. gatorguy Excel Discussion (Misc queries) 1 February 18th 05 10:51 PM


All times are GMT +1. The time now is 12:25 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"