what is the access equivalent to excel's vlookup function
Posted on 2009-04-26
what is the verticle lookup function in Access? In excel it would be =VLOOKUP("1 FOUR AP1", D1:H17, 2, FALSE) to return the value in the second field to the right of the lookup field. I would like to return data based on position since my query is pulling in rolling totals (i.e. the header is not alwasy the same (date) but is in the same position) based on sorting ascending or decending.