Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|