Excel HLOOKUP Formula Setup
Summary
Freelancer Client is hiring: Excel HLOOKUP Formula Setup.
Location: Remote
I have two related workbooks. Sheet 1 is my working file; Sheet 2 holds the customer information I need to reference. Both sheets share a unique reference code, and I want a single, reliable formula—ideally built with HLOOKUP—to pull the customer data into the correct columns of Sheet 1 every time the reference appears.
What you'll do:
• You review the current structure, insert the lookup formula where it belongs, and test it on a few rows.
Skills: Visual Basic, Data Processing, Data Entry, Excel, Excel VBA, Excel Macros, Data Visualization, Data Analysis, Data Integration, Data Management
Budget: $100–$400 USD
Source: Freelancer Client via Remote / Online. Apply on the source website.
Original
I have two related workbooks. Sheet 1 is my working file; Sheet 2 holds the customer information I need to reference. Both sheets share a unique reference code, and I want a single, reliable formula—ideally built with HLOOKUP—to pull the customer data into the correct columns of Sheet 1 every time the reference appears.
Here’s how I’d like to tackle it:
• We jump on a quick 30- to 45-minute call with screen-share.
• You review the current structure, insert the lookup formula where it belongs, and test it on a few rows.
• You leave me with a short note explaining how the formula works so I can extend or tweak it later.
I prefer HLOOKUP because the customer fields run across columns, but I’m open to VLOOKUP or INDEX/MATCH if you think they’ll be more robust.
If you’re comfortable solving this live and can get the formula working on the spot, let’s set up a call and wrap it up today.
Location & Details
Apply on source →About this listing
This remote opportunity was imported from Freelancer and is shown here for discovery. To apply, follow the link to the original posting.