Microsoft Excel function formula

Closed

Description

Setup Excel function to reference a value on another sheet by using an existing column value. It would take that refrenced value and post beside it in next column.

Example

You have following values on multiple sheets:

Sheet one

Col C Col D

ARZ blank

TB blank

ATL blank

Function would recognize all ARZ, TB, etc. on all sheets – then, to the column just to the right, reference a single sheet that holds a value as such:

Sheet 14

Col A Col B

ARZ 3

TB 17

ATL 6

End result: I can enter values (a single or 2 digit number) to sheet 14, column B. It would relate directly to column A. Then, every Col C on every other sheet would post Col B value (from sheet 14) to the column to the right of it on its respective sheet.

Sheet one

Col C Col D

ARZ 3

TB 17

ATL 6

I would send you Excel file, you would program this function then send it back to me.

File is attached.

Use PMB for comments or questions. I need this the quicker the better.

Skills:

See more: excel functional formula, microsoft excel formula sheet, number function, microsoft number, me excel, function number, formula it, excel &, send worksheet formula function, microsoft excel function formula, excel projects functions, formulas microsoft excel, formula project function, microsoft excel column value formula column, microsoft excel functions formulas, excel ord function, view next sheet function excel, formula sheet excel, excel formula function sheet, microsoft project function formula, ord excel function, excel formula ord, formula function excel, microsoft excel project function, excel formula sheet

Project ID: #159446

Awarded to:

hiratariq

Hi! Please see PM.

$50 USD in 1 day
(18 Reviews)
3.2

2 freelancers are bidding on average $50 for this job

Richardson183

I can do this. I can make Excel Macros in no time. Payment via Paypal Upon Completion.

$50 USD in 2 days
(0 Reviews)
0.0