View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default Multiple V Look up help?

If you are looking for a row with a specific combination of values in A and
B, then you can do what you're wanting by using the CONCATENATION feature,
making a helper column to the left of your data and concatenating A and B
together into one column, then doing your VLOOKUP on that
column...........BUT, VLOOKUP will return only the first instance of whatever
it's looking for.........AutoFilter will find all the matches, if it's
applicable...........

Vaya con Dios,
Chuck, CABGx3

"gb_S49" wrote:

I have a long list.
Column A contains Account Names (many repeated)
Column B Contains Orders (many repeated)
Column C Contains Invoice Cost.
Is it possible to use a vlookup from another worksheet that if detail in Col
A & B match then display Column C Detail?