Remember Me?

#1
Posted to microsoft.public.excel.misc
 external usenet poster Posts: 1
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

#2
Posted to microsoft.public.excel.misc
 external usenet poster Posts: 2,420
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

#3
Posted to microsoft.public.excel.misc
 external usenet poster Posts: 3,346
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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Milky Excel Worksheet Functions 1 August 20th 08 08:38 PM Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM inthestands Excel Worksheet Functions 2 July 19th 07 07:05 PM serene83 Excel Discussion (Misc queries) 5 June 27th 06 02:23 AM BCB New Users to Excel 7 May 13th 06 10:02 PM

All times are GMT +1. The time now is 08:12 AM.