combine data in excel/possible a easy question

  • Thread starter Thread starter Mistry
  • Start date Start date
M

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?
 
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?
Click to expand...

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
 
Back
Top