Results 1 to 5 of 5

Thread: Look up diagonally?

Threaded View

  1. Dec 19th, 2008, 04:37 AM #1
    paralyzedcitizen
    paralyzedcitizen is offline

    Thread Starter
    Addicted Member
    Join Date
    Jul 2008
    Location
    Guildford, UK
    Posts
    160

    Question Look up diagonally?

    Hi everyone,
    I'm using HLOOKUP to lookup a value in a table. (below)

    HLOOKUP('S_Victoria sections'!BV223,'7 fans'!I$11:BG$20,10)

    It looks along row 11 looking for the right number and (eg 2, circled green) and grabs the right flow rate from row 20 (circled red). What I also need is a formula to look up the value to it's left (circled blue).

    Any ideas?
    Attached Images Attached Images  

    "There'll be penguins on the moon"
    Reply With Quote Reply With Quote
« Previous Thread | Next 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


Click Here to Expand Forum to Full Width