VLookup Start from the Right Column and read to the left

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Darin (anonymous_at_discussions.microsoft.com)
Date: 05/24/04 

Date: Mon, 24 May 2004 14:41:04 -0700

Anyone know if it's possible to have the range in a Vlookup begin w/ the upper right most cell and column and read backwards from right to left? Thx.

Relevant Pages

  • RE: vlookup formula
    ... VLOOKUP only needs the lower value for each criteria. ... It gets its upper ... value from the next cell in the table. ...
    (microsoft.public.excel.misc)
  • RE: Any sugguestion to set up this Calculation?
    ... You can use VLOOKUP() with IFstatements, ... According to the below sample the 0.65 is a fit rate cell but i need to be ... we will say that sheet has been named CostTableSheet ... I am thinking a way to set up a template for other to use. ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Any sugguestion to set up this Calculation?
    ... I had a table consist of three Country. ... on my template I need to choose a correct country. ... Think of VLOOKUP as a single value, and it can be used in formulas just like ... According to the below sample the 0.65 is a fit rate cell but i need to be ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Any sugguestion to set up this Calculation?
    ... I had a table consist of three Country. ... on my template I need to choose a correct country. ... Think of VLOOKUP as a single value, and it can be used in formulas just like ... According to the below sample the 0.65 is a fit rate cell but i need to be ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Any sugguestion to set up this Calculation?
    ... Can Vlookup compare a few cell? ... For example for B P2PRate I need to compare a few cell. ... we will say that sheet has been named CostTableSheet ... I am thinking a way to set up a template for other to use. ...
    (microsoft.public.excel.worksheet.functions)