Thanks,I have tried with these formulas but failed to get the desired
results.can you help me with the work sheet formula.

"Vacation's Over" wrote:

helpfunctions

VLOOKUP
MATCH
COUNTIF

"TUNGANA KURMA RAJU" wrote:

Can anybody help me in solving this?
I have 2 worksheets.Sheet 1 contains master list all items.col A has names
of all items have 2 text strings separated by space" ".col b has id codes of
these items.
Sheet 1
col A col B
TAN VAL 7/S/4/7
TAN KAR 1/S/4/10
RELL ESW 1/D/1/10
REL SRI 3/S/1/2
TAN SRI 2/S/2/2
TAN VRM 1/S/5/10
GODA REK 2/D/1/2
Sheet 2
it is a query list contains few items of sheet 1(col A values) somewhere in
C6:C10 may contain 1 or more values.
Col C6:C10
TAN KAR
TAN VRM
RELL ESW
Now I need
1.compare the values in sheet 2 (col C6:C10) to sheet 1 col A and find row
numbers
Output:2,5,3
2.compare these output numbers with col B list's first character AND extract
them
Output:3/S/1/2
2/S/2/2
2/D/1/2
3.compare these col B values with col A values whether they starts with
"TAN" or not, count these values.
output: 1 (TAN SRI)