Results 1 to 5 of 5

Lookup column H and column I, H4 1st, I4 2nd, H5 1st, I5 2nd so on till rows 25

Threaded View

  1. 07-04-2019, 04:50 AM #1
    micope21
    micope21 is offline
    Valued Forum Contributor
    Join Date
    03-20-2011
    Location
    UK
    MS-Off Ver
    Excel 2007/10/16
    Posts
    840

    Lookup column H and column I, H4 1st, I4 2nd, H5 1st, I5 2nd so on till rows 25

    Hi all

    I'm looking a formula lookup column H4:H25 and column I4:I25 on to I30:i73
    This result i'm looking for like this (Lookup column H and column I, H4 1st, I4 2nd, H5 1st, I5 2nd so on till rows 25)

    Please see the sample file as I highlight it in yellow and green and explain for you to see it what result i'm looking for?

    Regard
    Attached Files Attached Files
    To help you by my post? it would be nice to click on to say "Thank you".
    If you are happy with a solution to your problem?
    Click Thread Tools above your first post,
    select "Mark your thread as Solved".
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Select column C and delete blank entire rows Till C300
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-04-2014, 08:55 AM
  2. Sum till the column till the date match
    By ursanil in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-02-2014, 06:29 AM
  3. copy column and it's row value till column blank found
    By nareshkt in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-23-2013, 03:20 AM
  4. Copy entire selected column to next columns till last column
    By siroos12 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-22-2013, 05:20 AM
  5. [SOLVED] Identify the last filled row in Column A and then drag formula in Column B till the same
    By bonny24tycoon in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-13-2012, 10:50 AM
  6. [SOLVED] SUM values in a column till you reach a flag in another column- Urgent
    By naveen.vinukonda@gmail.com in forum Excel General
    Replies: 2
    Last Post: 02-18-2005, 10:06 AM
  7. [SOLVED] SUM values in a column till you reach a flag in another column- Urgent
    By naveen.vinukonda@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2005, 10:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1