CONCATENATE your two columns together into a new column at the left of your
table, so you will be looking up 112A and 112C instead of 112 in cone column
and A in another, and 112 in one column and C in another, etc etc......

hth
Vaya con Dios,
Chuck, CABGx3



"PA" wrote in message
...
Dear All,

I try to use the simple vlookup function as follows:

Here is the source of info/list to be looked up:

Col A Col B Col C Row-1
Lookup List/Source of Info Row-2
ID Code Cost Row-3
111 A $100.00 Row-4
112 A $150.00 Row-5
114 A $200.00 Row-6
117 A $250.00 Row-7
112 C $15.00 Row-8
114 C $20.00 Row-9
117 C $25.00 Row-10
etc Row-11


Col A Col B Col C
Report/where Vlookup function needed
ID Code Cost
112 C $150.00 ====== =VLOOKUP(A18,$A$3:$C$11,3,FALSE)
Come with Result $150, suppose $15 as I try to lookup
Column A (ID) and Col B(Code) -with combination 112 and C
Not Combination 112 and A, which has result $150

114 A $200.00


Is there anyone can help me with "advance vlookup function" which can
"lookup" column A (ID) and Column B(Code) together and result with $15
instead of $150?

Many thanks for your help,

Warm Regards

PA