FAO: MS Excel geeks/experts

trengot
trengot Posts: 133
edited July 2007 in The Crudcatcher
Is it possible to lookup a row in a table by matching the data in two columns?

For instance in a table A1:E20 finding the row that has value "x" in column A and the value nearest to (but not necessarily equal to) "y" in column B. An then returning the value in the same row but column E.

I have tried everyway that i can think of but have not yet managed it.

Any help would be great.

Cheers
Stumpy Hardrock

Comments

  • richk
    richk Posts: 564
    Never tried it but would probably resort to VBA (macros in Excel) to do something like that.

    The alternative (again not tried, but I've seen once before) was something like a nested vlookup & hlookup combined...
    There is no secret ingredient...
  • formerlyknownasbonj
    formerlyknownasbonj Posts: 483
    email it to me and i'll do it for you by vba.
  • mbukfan
    mbukfan Posts: 3,052
    I've done two matching values by using nested vlookup
    <center>
    <font size="1"><font color="green">Only the truth hurts, but thats more than enough.</font id="green"> </font id="size1">
    <font size="2"> Andy</font id="size2">
    </center>

Categories