Excel vlookup/IF formula advanced

fina81

New Member
Joined
Feb 19, 2016
Messages
3
Hello everyone,

I am rather new here posting but this forum has anonymously helped me solve some of my Excel struggles.

So let me try to simplify and explain my current issue i do not manage to find a solution for.

I have an Excel table (1,000+ rows) from 2012 which is my basic starting point for 2015 calculations.
I need to compose nested function/ formula that
1. finds matching numbers/ codes of each employee - i would use vlookup
2. goes to cell XY and makes a test - if my cell is linked to validation sheet where I have all allocation keys, etc, take an exact formula/ number from validation sheet (will copy it into new workbook). Otherwise, if the cell contains number (just typed in) then copy that number. I would use IF formula.
I would like to avoid having links to some other documents (2012 file) or circular linkage to 2012 sheet but to simplify it and have it in one new workbook.

However, I do not manage to construct the formula so it works and it would be of a tremendous help and save me loads of time. Maybe my idea how to solve it with vlookup and IF functions is completly wrong so please feel free to suggest anything more comprehensive. :confused:

Besides, this is great opportunity for me to learn something new. Thanky you very much for any advice. :eek:

Best, fina
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,350
Attach a sample spreadsheet with expected results, remove any sensitive data.
You cant attach files on this forum.
Upload the file to an online storage site then place a link to it on this forum.
 

fina81

New Member
Joined
Feb 19, 2016
Messages
3
Does anyone have any idea how to deal with this?

My time is sersioly running out and to go by 800 items manually will kill me.

Please help,
 

Watch MrExcel Video

Forum statistics

Threads
1,123,141
Messages
5,599,969
Members
414,353
Latest member
ljhan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top