Excel VLOOKUP work

$250-750 AUD

취소됨

게시됨

5년 이상 전

$250-750 AUD

제출할때 지불됩니다

I want to do a VLOOKUP to move data from one spreadsheet to another. I can do VLOOKUPs but this has an element that I do not know the VLOOKUP script for. The spreadsheet 'ABR template' contains some data with Suburbs in Australia and telephone prefixes. The spreadsheet 'Postcodes by Suburb' contains some data with Suburbs in Australia and Postcodes. I need to combine these so that I have the suburbs and the postcodes in the same file with the telephone prefixes. The important field in file 'ABR template' that I want to match is column D (Suburb). If the suburb in column A of the file 'Postcode by Suburb' is contained within column D of the other spreadsheet then I need the postcode alongside that suburb in file 'Postcode by Suburb' inserting into the 'ABR template' file alongside the corresponding suburb. That is the easy bit, which I could do myself. Here is the more difficult part... Some suburb names are present more than once, e.g. St Leonards is present 4 times in 'Postcodes by Suburb'; 2 times in state NSW, 1 time in VIC, 1 time in TAS. St Leonard is only present 2 times in 'ABR Template' and that is okay. Where a suburb name is present in more than one state in file 'ABR Template' in column D the suburb name is followed by the state in brackets, e.g. 'St Leonards (NSW)', 'St Leonards (VIC)' etc. In file 'Postcode by Suburb' I have added a column alongside with the state of that suburb in brackets. What I need is a VLOOKUP that overrides present only in suburb field to say if the suburb in file 'ABR Template' contains 'Suburb' & '(State)' from columns A & C of file 'Postcode by Suburb' then use and insert the postcode from column B. I guess this would be termed as an overriding or secondary VLOOOKUP? Further to this, if a single State has a suburb twice e.g. 'St Leonards' in state '(NSW)' then from the 2 suburb postcode options insert the postcode that DOES NOT start with a number 1 following the underscore '_'. i.e. in the case of St Leonards (NSW) use postcode '_2065', not '_1590' because '_1590' starts with a 1 following the underscore. Instruction for VLOOKUP excluding the above extra info around STATE: In both tabs 1 and 2 of file 'ABR template' carry out the following Vlookup to insert data into ABR template. If column D of file ‘ABR Template’ contains the text (suburb name) in column A from file ‘Postcode by Suburb’ then place the postcode from column B of file ‘Postcode by Suburb’ into column F of file ‘ABR Template’. Overriding or Secondary Vlookup: If column D of file ‘ABR Template’ contains the text (Suburb) in column A from file ‘Postcode by Suburb’ AND column D contains the text from column C (State) then place the postcode from column B of file ‘Postcode by Suburb’ into column F of file ‘ABR Template’. i.e. Having the suburb and state overrides just having the suburb. Please confirm price and lead time to complete. Chris Morrison +61488818123 chris@[login to view URL]

Excel

프로젝트 ID: 18661371

프로젝트 정보

23 제안서

원격근무 프로젝트

활동 중 5년 전

돈을 좀 벌 생각이십니까?

이메일 주소

프리랜서 입찰의 이점

예산 및 기간 설정

작업 결과에 대한 급여 수급

제안의 개요를 자세히 쓰세요

무료로 프로젝트에 신청하고 입찰할 수 있습니다

23 이 프로젝트에 프리랜서들의 평균 입찰은 $330 AUD입니다.

@prameswara

Helo Sir Im excel VBA macro and formula Expert i can do make formula Vlookup to vlookup data from another workbook :) please ping me now and im able to discuss now before start :) Thank you Galih

$250 AUD 3일에

4.9

(419 건의 리뷰)

7.6

@TonmoyRoy111

Hello client I understand the scope of work involved in the project. I can surely build the formulas for you in excel. Please contact me for further details. Roy

$250 AUD 1일에

5.0

(496 건의 리뷰)

7.8

@SBITServices

Hello Chris, I can finish this task in 2 days for $100. I have checked the excel files and i can do the task which you mentioned is difficult. I can use VBA Macro script to match the correct suburb . I have 5 years experience in advanced concepts in excel like Pivot table, Vlookup, Charts, Data analyser etc. Check my reviews to confirm my work quality With Regards, Sai

$250 AUD 3일에

4.9

(452 건의 리뷰)

7.7

@periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Sure, will complete it quickly. First update by the 2nd day. for 400 AUD. Willing to take up your project. Thank you, Regards.

$400 AUD 3일에

5.0

(185 건의 리뷰)

7.0

@ksriniravi

Greetings! I have reviewed the 2 files and the requirements as well. The easiest way to meet the current requirements is to use macros. The macro for the current requirement is not complex at all. The look up would be entirely automated. The cost for macro development effort would be AUD 120 only. Since the project minimum price is specified as AUD 250, I am not able to bid below. I can complete in 2 days. If you can contact me, I can suggest a way to deal with this. Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based tasks every single day. I have 18 years experience in using Excel as part of my daily work life. Over the last 28 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. Have a Great Day! Srinivasan Krishnamoorthi

$250 AUD 2일에

5.0

(247 건의 리뷰)

7.1

@Nidhijain123

Hello, I have read and understood what has to be done in this task. I have sound experience in performing such kind of work as I have done lot of project of similar kind in the past. I think I can assist you in getting this task done with more focus on quality and getting it delivered on time. Regards, Nidhi

$250 AUD 10일에

4.9

(130 건의 리뷰)

6.9

@citijayamala

1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction

$250 AUD 10일에

4.7

(96 건의 리뷰)

6.4

@macroPOL

Hello, I am Excel and VBA expert. I have seen the files. I understand the requirements. I can do it in VBA (Excel VBA macros). If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback on over 80 projects. Jan

$250 AUD 3일에

5.0

(93 건의 리뷰)

6.1

@shahinrahimi

I can help you. I have rich experience in excel and VB, and I do my best to save your time and pocket. contact me. MySkills: • Data Management ..............................{Excel, Matlab} • Programming ......................................{Java, C#, VBA, PHP, HTML} • Web designing......................................{Wordpress} • 2D Graphic ...........................................{Photoshop, Macromedia Flash, ...} • 3D Graphic ...........................................{3dsMax, Blender, ...} • Engineering...........................................{AutoCad, Watergem, SewerCad, Flow3D, Elvis, ArcGIS, ...} • Researching .........................................{Green Energy, Solar cells, WaterManagement, ....} Services: ? Accuracy ? Customer satisfaction is my first "Priority" ? Time Commitment ? Availability Thanks, Shahin

$250 AUD 3일에

4.6

(62 건의 리뷰)

6.1

@sonarkaushik

Sir, I am well versed in these kind of jobs and can do your project as per requirement. I have over 12 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards

$366 AUD 3일에

4.6

(43 건의 리뷰)

5.6

@arash18k

Hi, I've read all your descriptions and imo these tasks will be easier to be done using vba rather than vlookup. if there is a specifict requirement for vlookup please let me know what is it. Ping me and I will start working on your project right away. Best Regards,

$300 AUD 4일에

5.0

(13 건의 리뷰)

4.9

@razaprof666

I am ready to work for you. Just provide me detail about work. Dont fear of budget and work. I have 5 years exprience in data handling. Just click me and assign me project. Thanks.

$277 AUD 1일에

5.0

(14 건의 리뷰)

4.4

@JSAConsultants

Hey! Please contact me first before placing any order. I am a qualified chartered accountant and working in an Audit/Consultancy firm as an auditor from 7 years. I had done ACCA, ICAEW, ICAP.I have experienced more than 40 companies on behalf of my firm. I was also working for Pepsi-Cola International at snacks plant. It is an honour for me to assist you in this task. Hoping for a positive response from you. *Fee will be negotiable according to your expected budget. I will share my firm profile when you contact me. Thanks Regards Muhammad Zaman

$250 AUD 10일에

5.0

(16 건의 리뷰)

4.5

@Mutindafestus

Hello i am happy to let you know that i can so this project, i had a similar case onother time, for my case, i was required to look up on more. than one column, i can promise to solve this problem as described please hire me thank you

$250 AUD 2일에

5.0

(3 건의 리뷰)

2.8

@Packey07

Hello! I can do this! I can make this happen for you! No fluff. Just hard work and accurate results. Thank you for your time. Mike

$777 AUD 5일에

0.0

(0 건의 리뷰)

0.0

@usmansam121

Hi, I am interested in your project. I am new here but I am a hard working and dedicated person, will give you on time quality work. We can negotiate the price.

$333 AUD 3일에

0.0

(0 건의 리뷰)

0.0

@vw7413653vw

Dear sender, I have good experience in admin and data entry work. please allow me to complete your work within given timelines. Thanks

$277 AUD 10일에

0.0

(0 건의 리뷰)

0.0

@ancaoprina

Excel specialist, fast typing. Hard working, deadline respected, self-motivated, easily adapt to new situations.

$444 AUD 7일에

0.0

(0 건의 리뷰)

0.0

@HamzaZahid5

I have more than 5 years experience in excel, web scraping, Data Analysis, Data management and Data Entry. if possible then I will send you some sample. Thank you.

$277 AUD 3일에

0.0

(0 건의 리뷰)

0.0

@shalinishri

Been working on similar projects from last few years and the description looks that I can easily handle the job without any hiccups or delay and will be a great opportunity for future partnerships on successfully delivering the project

$555 AUD 10일에