Thread: sorting help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ragdyer
 
Posts: n/a
Default sorting help

This time-lag between posts being visible on the "excelforum" site can be
exasperating ! ! !
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"worduser" wrote in message
...
Yes, all the companies in B are in A, but I tried your formula with no

luck.
Maybe I should be more specific.

I have two worksheet with the following numbers and headings:

Cheques (I renamed this worksheet)
Current Account Name CIS Code SIC Code Chq Volume
There are 2746 rows
4 columns

Cert Cheques (renamed)
Currenct Account Name CIS Code SIC Code Cert Chq Vol
There are 1093 rows
4 columns

I would like to organize them into 1 work sheet by CIS code, so that I can
see each company with the same CIS code of there cheque and certified

cheque
volumes.

"KellTainer" wrote:


Just a further question, does Worksheet A contain all the companies
listed in Worksheet B, as in B is a subset of A, or does B have
companies that A does not have.

If all the companies in Worksheet B are in A, you could use this
VLOOKUP Function.

Just create a heading Product 2 in D1, and and in D2 use this formula


=IF(ISNA(VLOOKUP(A2,Sheet2!$A$2:$C$3,3,FALSE)),0,V LOOKUP(A2,Sheet2!$A$2:$C$3
,3,FALSE))

replace the 0 with any null value you need, like "Nil" or something
else.

Drag down the formula to all the companies to achieve the desired
result.


--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile:

http://www.excelforum.com/member.php...o&userid=34322
View this thread:

http://www.excelforum.com/showthread...hreadid=546442