reverse vlookup

  1. S

    VBA code for reports from all sheets in a workbook

    Hi Everyone,:cool: I am in urgent need of vba code for my reports Attached is the sheet of my documents I get it from different vendors. Column AA contains the different status (e.g. Pending from vendor, Pending for OGC response, Pending for OGC submission etc. etc.) I want to have a...
  2. S

    How to vlookup with wild from lookup range

    Hi suppose I have the following data as an example <colgroup><col></colgroup><tbody> KB58 KB52 KB69 KB05 KB68 KB04 JY025 </tbody> and a lookup range as below <colgroup><col><col></colgroup><tbody> KB6 130 KB5 130 KB2 125 KB1 120 KB0 100 JY025 180 JY015 140...
  3. S

    Kind of a VLOOKUP but different

    Hello all, I'm using Excel to calculate my budget. In row "E", I have my balance after each transaction. In row "A", I have the date of that transaction. In cell "E2", I added this formula: =SMALL(E6:E3000,1) In cell "H2", I added this formula: =VALUE(E2) What formula would I need to add...
  4. K

    Using an array as "find_text" in a FIND formula / or kind of a reverse VLOOKUP

    This seems theoretically simple but I can't wrap my head around it: In A1 I have a text string, ie "Hello World!" I want to find "World" within the text string, as part of an IF(ISERROR...) formula: = IF(ISERROR(FIND("World", A1),"","Hooray!") Now, I want to find EITHER "Hello" or "World", the...

Watch MrExcel Video

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