Quick 15 minute job - EXCEL (VLOOKUP OR MATCH etc)
Budget: $10 – $30 AUD
$20 is the rae for this job
I have a spreadsheet with 2 tabs
tab 1 "Attendee" has all information in column "T"
tab 2 "Postcodes" tab has all the information i want to match
Example: When "atendee" column "t" Postcode number matches "Postcode number" in "Postcodes" tab column b - Push "postcodes" tab column G,J,L,Y and AC into "attendee" tab AY, AZ, ba, bb, bc
Notes:
Do not move or delete any columns
Do not use script or macro, should be only formula eg (MATCH / VLOOKUP etc)
ALL COLUMNS YOU will be working in are highlighted in orange
I have a spreadsheet with 2 tabs
tab 1 "Attendee" has all information in column "T"
tab 2 "Postcodes" tab has all the information i want to match
Example: When "atendee" column "t" Postcode number matches "Postcode number" in "Postcodes" tab column b - Push "postcodes" tab column G,J,L,Y and AC into "attendee" tab AY, AZ, ba, bb, bc
Notes:
Do not move or delete any columns
Do not use script or macro, should be only formula eg (MATCH / VLOOKUP etc)
ALL COLUMNS YOU will be working in are highlighted in orange