Formula to confirm entry in Col "C" is valid for data in Col "A"

  • Thread starter Thread starter VAPCMD
  • Start date Start date
V

VAPCMD

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.
 
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(A1,$G$1:$H$2,2,)=C1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cycle through list and put data found in col a into col d 6
Cross match data in Col A v/s Col B and display match in Col 3 3
Search range, find value in another col in corresponding row 3
Compare & align 2 cols of Employee Names in sorted alpha order withVBA 4
Flitering for unique records in Col B based on filtering in Col A 1
cell returning totals of 2 cols+ sending this value to another col 5
Move selected Text/Numbers from Col D to Col A/B 17
find multiple data cells for one data source 8

Back
Top