USING IF/VLOOKUP STATEMENT TO VERIFY A VALUE
Closed
MIKE78
-
Aug 19, 2009 at 02:37 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 19, 2009 at 09:49 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 19, 2009 at 09:49 PM
Related:
- USING IF/VLOOKUP STATEMENT TO VERIFY A VALUE
- Fenix internet on bank statement - Guide
- Verify whatsapp number online - Guide
- Application for bank statement sbi - Guide
- How long does it take facebook to verify id - Guide
- Excel if statement - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Aug 19, 2009 at 09:49 PM
Aug 19, 2009 at 09:49 PM
suppose your data from row one dwon in column A and B are as follows
1 6
2 7
3 8
4 9
5 3
in C1 type this formula
=IF(ISNA(VLOOKUP(A1,$B$1:$B$100,2,0)),"no","yes")
copy c1 down you will get
1 6 no
2 7 no
3 8 yes
4 9 no
5 3 no
1 6
2 7
3 8
4 9
5 3
in C1 type this formula
=IF(ISNA(VLOOKUP(A1,$B$1:$B$100,2,0)),"no","yes")
copy c1 down you will get
1 6 no
2 7 no
3 8 yes
4 9 no
5 3 no
kaiyasit
Posts
30
Registration date
Sunday August 9, 2009
Status
Member
Last seen
April 20, 2010
12
Aug 19, 2009 at 06:12 AM
Aug 19, 2009 at 06:12 AM
Use "CONDITIONAL FORMATING"
by select B column and use "conditional formating"
select "formula is"
=NOT(ISERROR(VLOOKUP(B1,A:A,1,0)))
and select format that you need to see when value in column B matched value in column A.
Please try...it's may be help you
Best regards,
Kaiysit Phanmakorn
kaiyasitp@gmail.com
by select B column and use "conditional formating"
select "formula is"
=NOT(ISERROR(VLOOKUP(B1,A:A,1,0)))
and select format that you need to see when value in column B matched value in column A.
Please try...it's may be help you
Best regards,
Kaiysit Phanmakorn
kaiyasitp@gmail.com