VLOOKUP

CHOOTOO · May 20th, 2002, 02:21 PM

I have two worksheets and I need to know how to do a vlookup to validate the one worksheet. I need the lookup to tell me that the data in column A on the second worksheet is valid if it is found in column A on the first worksheet.

sen_edp · May 20th, 2002, 02:42 PM

Hi !

I think that a simple countif function does it. No need to go for vlookup as i see it.

in the next column i.e. B2 in sheet2 insert this formula and copy down as you wish
=COUNTIF(Sheet1!$A$2:$A$100,A2)
IF YOU GET A NUMBER > 0 THEN IT IS VALID

Yogi Anand · May 20th, 2002, 02:58 PM

If you are trying to verify that the contents of cells in column A in both sheets are identical, then use the following formula in cell B1 of sheet2

=Sheet1!A1=A1 ... if the result is TRUE, they are identical
use the same technique for all other cells by replicating the formula in cell B1 to other cells.

May 20th, 2002, 02:42 PM	#2
sen_edp Board Regular Join Date: Mar 2002 Location: Hellas Posts: 553	Hi ! I think that a simple countif function does it. No need to go for vlookup as i see it. in the next column i.e. B2 in sheet2 insert this formula and copy down as you wish =COUNTIF(Sheet1!$A$2:$A$100,A2) IF YOU GET A NUMBER > 0 THEN IT IS VALID __________________ Best Regards Andreas

May 20th, 2002, 02:58 PM	#3
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	If you are trying to verify that the contents of cells in column A in both sheets are identical, then use the following formula in cell B1 of sheet2 =Sheet1!A1=A1 ... if the result is TRUE, they are identical use the same technique for all other cells by replicating the formula in cell B1 to other cells. __________________ Regards! Yogi Anand, D.Eng, P.E. Energy Efficient Building Network LLC www.energyefficientbuild.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 20th, 2002, 02:21 PM	#1
CHOOTOO New Member Join Date: May 2002 Location: AKING Posts: 1	I have two worksheets and I need to know how to do a vlookup to validate the one worksheet. I need the lookup to tell me that the data in column A on the second worksheet is valid if it is found in column A on the first worksheet.