vloockup

  1. F

    compare 4 different columns from 2 tables and extract data

    hi, i have got 2 tables. I want to compare 4 columns from both these tables and retrieve data from table2 into table1, if the criteria matches. Now the problem is that the values to be compared will not match exactly. 2 columns would match exact 2 columns would be similar Table1 Table2 The...
    • fowzan
    • Thread
    • formula and vba funciton index & match vloockup
    • Replies: 5
    • Forum: Excel Questions
  2. K

    IF and Vlook Up Formula

    Hello, I need help with "vlookup" and "If" formula together under "Deal Type ID" below. I need to assign a value to " Wholesale" if there is "D" in "deal type" column "A" and the vlookup Lender Name to look up either " Outside Finance" or "Cash" First Sheet...
  3. epardo87

    repeated values in cloumn A, return if column B=X at least in one row

    Hello there, So I have: column A where a value can be repeated unlimited times column B can vary between X or Y Column C is where the formula needs to go: If value in column A contains an "X" in column B, in any of the rows where it appears, then "OK" I'd really appreciate your help...

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
Back
Top