Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup/if statement?
I have 2 spreadsheets with data from 2 systems.
What I need is to take specific data from sheet 1 and match it to the corresponding line in sheet 2. The problem comes in that each sheet only has a unique entry if I search based on a combination of 4 columns (item #, date, location and quantity). For any one of these search items there will multiple entries, but for the combination of all 4 there should be one unique entry. How can I accomplish this to compare the two spreadsheets? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
IF Statement | New Users to Excel | |||
How to calculate a sum as one outcome of an IF statement | Excel Worksheet Functions | |||
How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) | |||
Statement | Excel Worksheet Functions |