v look up

  1. P

    VLOOKUP lookup value range workaround - If statement?

    Hello, My understanding of VLOOKUP function is that you cannot insert a range of cells as the lookup value. So, I am trying to find a workaround that only outputs data if the value in a 'lookup range' is not blank. Please see the attached original_data.jpg. I would like to return Customer...
  2. S

    pulling one coumn & related data from one file to other in excel

    Dear friends I have two excel files 1. master 2. marks There are multiple columns in each file . . now i am creating one more file called combine. my reference column is barcode column in both master & marks file. i want to bring all the data in master file to combine file as well as data...
  3. O

    V Look Up/If Formula

    Hi there Please see the attached sample - I'm looking for some help with a formula. Location - https://www.dropbox.com/s/x1b80aj5hm3fmfb/Sample.xls?dl=0 On the 'Valuation Sheet' I want the Call Out Charge column P to auto fill with the cost of the call out which is determined by the type of...
  4. S

    V look up

    Hi I have in Sheet 1 a table of 3 columns showing Column A = From Date Column B = To Date Column C = Employee who should manage the shift . His Employment number is entered here. In Sheet 2 i have Invoice dates in Column A. For each dates in column A, i want to enter the...
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.

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