Vlookup
Posted by B Ferguson on November 03, 2000 5:04 PM
Hi All,
I am wondering if there is a method of using the vlookup function
to reference more than one cell For example..
A B C
845623 0 Location 1
845623 1 Location 2
845623 2 Location 3
My goal is to use column A and B as the lookup reference
to return the correct value in column C
Any ideas?
Thanx!
Posted by Celia on November 04, 2000 3:18 AM
Put the column A lookup value in cell D1 and the column B lookup value in cell E1, then use the following array formula (Ctrl+Shift+Enter) :-
=INDEX(C1:C100,MATCH(D1&E1,A1:A100&B1:B100,0))
Celia
=INDEX(C1:C100,MATCH(D1&E1,A1:A100&B1:B100,0))
Posted by Neil on November 05, 2000 12:56 AM
Posted by Neil on November 05, 2000 12:58 AM
If you have to use VLOOKUP try =VLOOKUP(A1&B1,etc....
