Complex logical/conditional formula
Thank you!! This worked like a charm!
"Biff" wrote:
Hi!
Try something like this:
A1 = some acct #
B1:
=IF(COUNTIF(Sheet2!Acct_#_Range,A1),INDEX(Sheet2!A cct_title_range,MATCH(A1,Sheet2!Acct_#_range,0))," ")
Biff
"Ash" wrote in message
...
I am working between two worksheets. In one worksheet I have a list of
account numbers. In the second worksheet I have the same account numbers
in
a different order. What I am trying to do is, If the account number from
worksheet one is found in the column with the account numbers in worksheet
two, I want to display the matching title for the account number that is
in
the same row but different column in worksheet two.
So essentially (if acct # from column x in wks 1= an acct in number in
column m from wks 2, display the corresponding title in the same row of
the
matching acct # found in column m). Is this possible?
|