How to find out which paper has been received and which paper has not been received.

[GVN KUMAR]

sir
I take the papers from the client for bank govt subsidy loan application filing purposes..
How do we find out what papers we have taken from them and what papers are still due?

We have written the list of papers taken, papers taken by first letter code word.
If you enter that word, a tick mark will appear, if not, the mark will be blank.
How to write a formula for this.

✔​

Photo

Aadhar

Caste

Study

Ration

Bank copy

PAN

Ele Bill

Voter Card

House Tax

Insurance

Land Document

MSME

Labour

Cibil

code word​

p

a

c

s

r

b

pan

e

v

h

i

d

m

l

cb

anop singh sweets 5 llk​

✔

✔

✔

✔

✔

✔

✔

✔

Badugu hemanth kumar​

✔

✔

✔

✔

✔

✔

✔

✔

Badugu Sujatha​

✔

✔

✔

✔

✔

✔

✔

✔

✔

✔

Kancharla Ratna Kiran​

✔

✔

✔

✔

✔

✔

✔

kareem baig​

✔

✔

✔

✔

✔

✔

✔

✔

✔

✔

✔

✔

✔

✔

kondaveeti mangamma​

✔

✔

✔

✔

✔

✔

✔

✔

Pedapalli syamkumari​

✔

✔

✔

✔

✔

✔

✔

✔

✔

✔

✘​

​

 

[GVN KUMAR]

The formula you wrote is exactly what we expected, and it works perfectly.

Thank you for taking your valuable time to read and answer our question.
Saved us a lot of time

thank you

Hope that God also gives you more knowledge and that more people can be helped through this medium.

 

[GVN KUMAR]

The answer given by you is very straightforward and clear, with no doubts or questions. thank you

 

[bosco_yip]

Another option like this:

1] In B3, formula copied across right and down:

=IFERROR(IF(COUNTIF(INDIRECT("'"&$A3&"'!C:C"),B$2),"✔","✘"),"")

2] Pls see attachment.

 

[GVN KUMAR]

You have answered this question in a very broad way
We did not expect such a broad response sir. Thank you very much.

Thank you for giving us your valuable time

sorry for the late replay sir