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...

Some videos you may like

This Week's Hot Topics