Vlookup query

[MrsSquibbles]

Hi, I'm a newby to the site so first of all would like to say thanks for letting me join

My question (which may seem rather basic) is that I have 2 worksheets taken from different workbooks.
The first one contains information for interested customers, ie. company name, contact, type of company, address, postcode etc; the second one contains the details of all companies who actually submitted an application including all their contact details, names, address, postcode, tel no etc.
I need to compare the two spreadsheets so I can identify by POSTCODE only those who submitted an application. It should be straight forward but I cant seem to get going with this.
Any help would be very much appreciated.
Thanks, Michelle

 

[oldbrewer]

the second sheet is those who actually submitted an application

you say you want to identify them

they are on sheet 2

 

[MrsSquibbles]

the second sheet is those who actually submitted an application

you say you want to identify them

they are on sheet 2

Hiya, thanks for responding. Yes, the data on sheet 1 is the "potential applicants", sheet 2 is actually a list of 2795 names & addresses & postcodes. I need to identify from that list & match applicants. I hope that makes sense? I'm thinking perhaps it might be match rather than lookup.

 

[oldbrewer]

fred					tom
bill					fred
dave					bill
					jim
					james
					sid
					elvis
					dave
					colin
		you want to identify fred, bill and dave on the second list?

<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[MrsSquibbles]

Hiya, in short yes. The first worksheet contains postcodes which is what I am trying to identify on the 2nd worksheet as that is the unique identifier between the two sheets. I then plant to use conditional formatting to highlight them.

 

[oldbrewer]

fred					tom
bill					fred
dave					bill
					jim
					james
					sid
					elvis
					dave
					colin
		you want to identify fred, bill and dave on the second list?
		fred bill and dave have been nade bold italic
		conditional formula in F1 (tom)
		=OR(F1=$A$1,F1=$A$2,F1=$A$3)=TRUE

<colgroup><col span="9"></colgroup><tbody>
</tbody>