M Mark1ace1 Jun 6, 2004 #1 Can you use VLOOKUP to check left of the cell, rather than the right without having to change cells around? Mar
Can you use VLOOKUP to check left of the cell, rather than the right without having to change cells around? Mar
B Bob Phillips Jun 6, 2004 #2 Best way is to use MATCH to find the row in the lookup column, then use INDEX to get the value to the left, such as =INDEX(A1:A100,MATCH("test",C1:C100,0)) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
Best way is to use MATCH to find the row in the lookup column, then use INDEX to get the value to the left, such as =INDEX(A1:A100,MATCH("test",C1:C100,0)) -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct)
