| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing columns in sheets
Thanks for reading this post.
In Sheet 1 column B I have a list of numbers(eg. Staff No) and in column F there are some values (eg. Incentive) against each number. Sheet 2 column C contains a list of numbers which includes many of the numbers from the previous sheet (ie. sheet 1 Column B) but not in the same sequence. Column H has the values. I want to compare sheet 1 column B with sheet 2 column C and where a match is found to display the corresponding value from sheet 1 column F in sheet 2 column J. How can I achieve this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing Two Sheets | Excel Worksheet Functions | |||
| Comparing multiple columns in two sheets | Excel Worksheet Functions | |||
| comparing 2 sheets | Excel Worksheet Functions | |||
| Comparing columns iin 2 sheets to generate one | Excel Worksheet Functions | |||
| comparing 2 similar columns on seperate work sheets in 1 workbook | Excel Discussion (Misc queries) | |||
Threaded Mode
