VLOOKUP

[samsung92]

Completely new to Excel.
I have 2 columns of data and I want to search the second column to see if any data in the first column is there.
I have been told about VLOOKUP but do not know how it works.
If someone could let me have a formula that would be great.

 

[GlennUK]

What result do you want exactly? A Yes or No somewhere? Or what?

 

[samsung92]

If I can get back a result of YES or No that would be great

 

[MarkAndrews]

=IF(VLOOKUP(Q2,A:B,2,FALSE)=TRUE,"Yes","No")

Replace Q2 with the word you are looking for (cell reference)

A:B is the table of data it is looking in, extend as required

2, is the cell reference

False will give you exact results

 

[samsung92]

Does not seem to work?
The data I am trying to look up against is all numbers if that helps.

 

[Jon von der Heyden]

Hi

Try:

=IF(ISNA(VLOOKUP(Q2,A:B,2,0)),"No","Yes")

Regards,
Jon

 

[Peter_SSs]

samsung92

See if this is what you want. Formula in C2 (copied down):
=ISNUMBER(MATCH(B2,A:A,0))

Mr Excel.xls
	A	B	C	D
1	List 1	List 2	Result
2	23	0	FALSE
3	apple	23	TRUE
4	B Smith	45	FALSE
5	23.56	F Smith	FALSE
6	856	apple	TRUE
7	2 o'clock	3 o'clock	FALSE
8		14	FALSE
9		89	FALSE
10
Check Lists

 

[samsung92]

Many thanks to everyone for your help.
Here is the data to show what I need to do,I want to see how many times the data in column C apperas in column R.

Mat. doc. (GR Date) Pstg date PO Stat Date (N/A not on ZMDP) MvT Time Description Material Plnt SLoc Quantity User Type VS OTD STO.Purch.doc STO OTD
4550043789 ON TIME
5000292052 3-Oct-05 4550039092 30-Sep-05 101 08:18:18 UNC STUDBOLT 041338 2000 FRN 4 DSCARG STO 4550048930 ON TIME
5000292341 3-Oct-05 4550037900 28-Sep-05 101 14:03:18 SETSCREW N/P M12 x 55MM 119612055 2000 FRN 3 DSCARG STO 4550049846 LATE
5000292277 3-Oct-05 4550038459 04-Oct-05 101 13:57:54 REDUCER 334011508 2000 FRN 2 DSCARG STO 4550050192 ON TIME
5000292340 3-Oct-05 4550034700 22-Sep-05 101 14:02:58 RTD SUB-ASSEMBLY THRUST BEARING 3993/7063/712 2000 FRN 1 DSCARG STO 4550050192 ON TIME
5000292346 3-Oct-05 4550034700 22-Sep-05 101 15:04:05 RTD SUB-ASSEMBLY THRUST BEARING 3993/7063/712 2000 FRN 1 DSCARG STO 4550050456 ON TIME
5000292331 3-Oct-05 4550038976 05-Oct-05 101 13:59:10 SEAL TO SUIT SB474/C 64/07226003/16 2000 FRN 8 DSCARG STO 4550050986 ON TIME
5000292051 3-Oct-05 4550036885 02-Sep-05 101 08:17:18 PRESSURE TRANSMITTER - ATEX 64/60001108/16 2000 FRN 1 DSCARG STO 4550051266 ON TIME

 

[Peter_SSs]

samsung92

I think you can see that we haven't really got a clue what is in what column. See if this simple example is any help. Formula in D2 (copied down):
=COUNTIF(R:R,C2)

Mr Excel.xls
	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	List 1	Count in Col R														List 2
2	red	1														yellow
3	blue	3														pink
4	yellow	1														blue
5	orange	0														blue
6	green	1														red
7																black
8																green
9																blue
10
Check Lists

 

[samsung92]

I have now managed to do my first VLOOKUP run.
Many thanks to you all for your help.
What an excellent site