formula for shauna
 

I'm trying to write a formula that matches a value in cloumn A of sheet 1
with column a sheet 2 and return the value of column D of sheet 2 in sheet 1
when coulmn a in both sheets match. If they don't match I want a n/a to
return.

formula for shauna
 

One Way
=INDEX(Sheet2!D:D,MATCH(Sheet1!A1,Sheet2!A:A,0))


"shauna" wrote:

I'm trying to write a formula that matches a value in cloumn A of sheet 1
with column a sheet 2 and return the value of column D of sheet 2 in sheet 1
when coulmn a in both sheets match. If they don't match I want a n/a to
return.

formula for shauna
 

And if you want to return neat looking blanks: ""
instead of ugly #N/As for unmatched cases

In Sheet1,
Place in say, B2:
=IF(ISNA(MATCH(A2,Sheet2!A:A,0)),"",INDEX(Sheet2!D :D,MATCH(A2,Sheet2!A:A,0)))
Copy B2 down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,800 Files:359 Subscribers:54
xdemechanik
---
"shauna" wrote:
I'm trying to write a formula that matches a value in column A of sheet 1
with column a sheet 2 and return the value of column D of sheet 2 in sheet 1
when column a in both sheets match. If they don't match I want a n/a to
return.