LinkBack URL
About LinkBacks
Probably an easier way to do this, but try this, copied down...
=IF(ISERROR(VLOOKUP(B2,Location!$A$2:$A$103,1,0)),IF(ISERROR(VLOOKUP(C2,Location!$A$2:$A$103,1,0)),"","Include"),"Include")
Probably an easier way to do this, but try this, copied down...
=IF(ISERROR(VLOOKUP(B2,Location!$A$2:$A$103,1,0)),IF(ISERROR(VLOOKUP(C2,Location!$A$2:$A$103,1,0)),"","Include"),"Include")
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks for the reply it has worked for most scenarios. When I applied this to the full membership list I had some failures due to the state of the address data. What I am finding is that the vlookup is looking for exact text where what I need it to do is find the Location anywhere in the address 1 or address 2 field. eg if Location is Christchurch - Address line 1 is Cranfield Christchurch it will return Christchurch and not blank as at presnt.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks