P
pam
I have a spreadsheet which has info pulled from a
mainframe report. The report has 5 columns, and two of
these columns have descriptions. My problem is that for
the most part the descriptions in the rows are the same,
but when I have one that is different, I want the
index/match statement to get the 2nd title. Below is an
example and what I have so far. (Basically I want it to
look for a match in column B and if that is an error, I
want it to return the value in Column D.)
Thanks for your help
~Pam~
DESC 1 PdBudg1 DESC2 CurrPd PdBudg2
FIRST 2,000 FIRST 1,000 2,000
FIRST 2,000 SECOND 1,000 2,000
IF(ISERROR(MATCH($B3,$D$2:$D$400,0)),"G3",INDEX
($C$2:$C$400,MATCH($B3,$D$2:$D$400,0)))
mainframe report. The report has 5 columns, and two of
these columns have descriptions. My problem is that for
the most part the descriptions in the rows are the same,
but when I have one that is different, I want the
index/match statement to get the 2nd title. Below is an
example and what I have so far. (Basically I want it to
look for a match in column B and if that is an error, I
want it to return the value in Column D.)
Thanks for your help
~Pam~
DESC 1 PdBudg1 DESC2 CurrPd PdBudg2
FIRST 2,000 FIRST 1,000 2,000
FIRST 2,000 SECOND 1,000 2,000
IF(ISERROR(MATCH($B3,$D$2:$D$400,0)),"G3",INDEX
($C$2:$C$400,MATCH($B3,$D$2:$D$400,0)))