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)
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
