Markt
"MarkT" wrote:

For a more visual explanation:

SpreadsheetA
column
.............A.........................B
1..........Customer ID
2..........1001
3......... 1005
4..........1099
5..........1255

there is other information in SpreadsheetA, in the other columns, but I am
only using info from SpreadsheetB if the Customer ID is listed in SpreadsheetA

SpreadsheetB
Column
...............A..................B..............C
1..........Customer ID.....Name........Sale

3..........1001...............ABC Co.......$500.00
4..........1002...............XYZ Co.......$900.00
5..........1255...............SKL Co.......$200.00
6..........1333...............ASD Co......$800.00

Looking to compare both Customer ID columns and printing the info if there
is a match:

2|... 1001 $500.00 with: =VLOOKUP(A2;SpreadsheetB!$A$2:$C$5;3;FALSE)

4|... 1255 $200.00 with: =VLOOKUP(A4;SpreadsheetB!$A$4:$C$7;3;FALSE)

it is very importend that the both coustomerID in SpreadsheetA and
SpreadsheetB have the same typ, p.e. both are text or both are number

I am using Excel 2007. I have looked in the archives but have not been able
to find my answer. Thanks for your anticipated help!

with regards
Marion