combine data in excel/possible a easy question

[Mistry]

i have to sheets A and B. I would like to compare one of the cols in
Spreadsheet A and if it exisits in Spreadsheet B (ColA) would like to
insert a value in spreadsheet B (col b)... is this possible?

 

[David Heaton]

i have to sheets A and B.  I would like to compare one of the cols in
Spreadsheet A and if it exisits in Spreadsheet B (ColA) would like to
insert a value in spreadsheet B (col b)... is this possible?

Your question is a little vague but...

This formula checks if a given value in sheet2 (a1) is anywhere in
sheet1 col A and then returns the corresponding value in col B of
sheet1

=INDEX(Sheet1!$A$1:$B$500,MATCH(A4,Sheet1!$A$1:$A$500,0),2)

if you want to avoid any #N/A that appear when not found use this

=IF(ISERROR(MATCH(A1,Sheet1!$A$1:$B$500,0)),"",INDEX(Sheet1!$A$1:$B
$500,MATCH(A1,Sheet1!$A$1:$A$500,0),2))

hth

Regards

David