Macro for Lookup

[macdca]

Can anyone tell me how to write a macro for a VLOOK up procedure, lining to a worksheet which looks up over 2 worksheets?

Thanks

 

[VoG]

In the sheets that you are trying to lookup from, which column contains the text Post Code and which column contains the value that you wish to return?

 

[macdca]

Look up in A and the value I want in a new column is in column C of the 2 look up sheets

 

[VoG]

Try

=VLOOKAllSheets("Post Code",A2:C6500,3,FALSE)

If you are trying to look up an actual postcode, not the text Post Code you need to change the formula accordingly.

 

[macdca]

Yes I am looking up actual post codes against a look up of actual post codes and want to return the wider area, from column C of the look up - what change do I need to make to the formula??

 

[macdca]

Also, when i place the curser in the formula the selection is from, the data sheet I am trying to populate rather than the look up worksheets, is this right?

 

[VoG]

Where are your actual postcodes?

 

[macdca]

They are in column E of my main datasheet. they should look up column A of the look up (worksheets named 1 2 and 3) and display the wider area from column C of the look up?

 

[macdca]

sorry I should have said. the wider areas are to be displayed in a new column in my datasheet (column H) where I have pasted the look up formula

 

[VoG]

Try in row 2 copied down

=VLOOKAllSheets(E2,A$2:C$6500,3,FALSE)

 

[macdca]

GETTING THERE I THINK, THE FIELDS NOW DISPLAY <TABLE style="WIDTH: 62pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=82 border=0 x:str><COLGROUP><COL style="WIDTH: 62pt; mso-width-source: userset; mso-width-alt: 2998" width=82><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl22 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 62pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" align=middle width=82 height=17 x:err="#NAME?">#NAME?

</TD></TR></TBODY></TABLE>