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
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,425
Office Version
  1. 2019
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,
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,707
Messages
5,833,241
Members
430,199
Latest member
Petty queen

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