Formula to confirm entry in Col "C" is valid for data in Col "A"
Looking for formula that will confirm (True/False) that the (single
character) entry in col "C" is a valid entry for data in col "A". I have setup a table that shows the 9 codes in col "A" (a, b, c, d, e, f, g, p, and q) and the codes that correspond to them. Any assistance appreciated Thanks in advance. |
Formula to confirm entry in Col "C" is valid for data in Col "A"
=C1=VLOOKUP(A1,lookup_table,2,False)
-- __________________________________ HTH Bob "VAPCMD" wrote in message ... Looking for formula that will confirm (True/False) that the (single character) entry in col "C" is a valid entry for data in col "A". I have setup a table that shows the 9 codes in col "A" (a, b, c, d, e, f, g, p, and q) and the codes that correspond to them. Any assistance appreciated Thanks in advance. |
Formula to confirm entry in Col "C" is valid for data in Col "A"
Hi,
You may need to get a little fancier because if the A1 entry is not listed in the table the previous formula will return #N/A. In this case that problem also displays FALSE. =IF(ISNA(VLOOKUP(A1,$G$1:$H$2,2,)),FALSE,VLOOKUP(A 1,$G$1:$H$2,2,)=C1) -- If this helps, please click the Yes button Cheers, Shane Devenshire "VAPCMD" wrote: Looking for formula that will confirm (True/False) that the (single character) entry in col "C" is a valid entry for data in col "A". I have setup a table that shows the 9 codes in col "A" (a, b, c, d, e, f, g, p, and q) and the codes that correspond to them. Any assistance appreciated Thanks in advance. |
All times are GMT +1. The time now is 01:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com