Column Lookup

  • Thread starter Thread starter N Harkawat
  • Start date Start date
N

N Harkawat

place this on cell E2 aand fill it down
=vlookup(a2,c$2:d$1000,2,0)
 
wMicorsoft Office Excel 2003
I need to look up an answer from a column based on another column and place
the answer in yet another column. See example

Col A Col B Col C Col D Col E (the answer)
Apple 20 Orange 5 35
Orange 10 Apple 35 5
Search Col C based on Col A and return answer to Col E from Col D
 
You must log in or register to reply here.

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.

Ask a Question

Similar Threads

Case Sensitive v-lookup needed 3
Vlookup Help 5
Lookup reference help 3
Very strange behaviour of VLOOKUP in Excel 2010 4
Average problem 1
Conditional formula 3
Entering a cell with Criterias 5
Vlookup Multiple Matches 7

Back
Top