vlookup if

  1. S

    IF(ISNA(VLOOKUP to match 1 column with another

    So I moved the data that I want to use into 1 sheet and I want to compare data on Column 1 with Column B. I want to find out if the data on Column 1 also exist in Column 2. I am using "1" for exist, and "0" for not existing. The problem is, first I tried using my office notebook, but all the...
  2. Jyggalag

    Excel vlookup problems 2

    Dear all, Please note that I made an earlier thread and am now continuing with the same sheets as before, but also including a new file (file 3). The old thread is here: Excel vlookup problems I currently have three files, file (1): File 2: And file 3: Currently, file 3 has the...
  3. Y

    If inside if(vlookup)

    Hello, I need some help, I have a worksheet and in one cell I check if it equals to 0 it should do vlookup to other sheet and get from there the information. But I want to add to it that if the vlookup is also equals to 0 so it should do antoher vlookup to another worksheet and get the...
  4. S

    ADD-IN additional IF to Already Existing IF Function - VLOOKUP COMPARISON Add-in

    Good Morning accomplished VBA peers. I'm running into a problem. I need to add-in an additional IF parameter and it's complicated. It touches on parts of VBA that I am not comfortable with and frankly, I don't know how to begin. This macro was essentially written by this board anyhow...
  5. V

    Vlookup- multiple values

    The cells refer to numbers. I am looking to match numbers on one worksheet to another. Some cells contain the same numbers and it pulls the first one... This is a formula I am working with. The problem is that it picks out the first value that T15 matches to, and disregards the rest of the...
  6. U

    IF/VLOOKUP Statement

    Hi Hopefully somebody can help me as my eyes are beginning to burn I have been looking at this so long! Basically I am exporting data from another programme in to Excel and need to perform a less than ordinary (for me) VLOOKUP to another workbook. The aim is to look up the value of column H...

This Week's Hot Topics

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