M
Marti
Is it possible to use vlookup for 2 criteria? I want to go to another tab in
my workbook and lookup the value that meets 2 criteria. in the example below,
I need the id# and project id # to match values on the other tab and return
the $ value that matches both.
ID # Project ID Amount
123 0523 $1,000
456 0645 $2,000
789 0752 $4,000
028 0523 $5,000
my workbook and lookup the value that meets 2 criteria. in the example below,
I need the id# and project id # to match values on the other tab and return
the $ value that matches both.
ID # Project ID Amount
123 0523 $1,000
456 0645 $2,000
789 0752 $4,000
028 0523 $5,000