Results 1 to 12 of 12

Thread: vlookup across multiple column range

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 12-06-2024, 07:40 AM #4
    p45cal
    p45cal is offline
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,970
    try something along the lines of: 
    =INDEX('Raw data'!$F$1:$F$6,MIN(IF((A7='Raw data'!$A$2:$E$6),ROW('Raw data'!$A$2:$E$6))))
    Note red numbers in the formula:
    =INDEX('Raw data'!$F$1:$F$6,MIN(IF((A7='Raw data'!$A$2:$E$6),ROW('Raw data'!$A$2:$E$6))))
    (I've been lazy.)
    Last edited by Aussiebear; 12-06-2024 at 05:28 PM.
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

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