I have seen a ton of samples on looking up a table to return a value when there is a match but none on doing a lookup and matching two values then returning the third. (Or I am so confused, that I missed it) I am working on Excel 2000 (moving onto 2003 in two months) and need to do the following:
1. I have a workbook with data in Column "A", "B" and "C".
Data in "A" can repeat itself but the data in "B" will
only occur once.
e.g.) Column A Column B Column C
N/C 3106 0744
N/C 3580 1191
N/C 4223 0397
2. I need to open this workbook to lookup the value in "A"
and when there is a match, then lookup the value in "B"
to see if I have a match. If I match on "A" and "B",
then return the value in "C".
I am currently doing a VLookup with matching a single column and returning the value next to it. Now I need to match on two values then return the third value. Any suggestions or sample coding would be greatly appreciated (as always).
1. I have a workbook with data in Column "A", "B" and "C".
Data in "A" can repeat itself but the data in "B" will
only occur once.
e.g.) Column A Column B Column C
N/C 3106 0744
N/C 3580 1191
N/C 4223 0397
2. I need to open this workbook to lookup the value in "A"
and when there is a match, then lookup the value in "B"
to see if I have a match. If I match on "A" and "B",
then return the value in "C".
I am currently doing a VLookup with matching a single column and returning the value next to it. Now I need to match on two values then return the third value. Any suggestions or sample coding would be greatly appreciated (as always).