Comparing columns and returning value
Solved/Closed
Related:
- Excel formula to compare two columns and return a value
- Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array - Best answers
- If two cells match then return value - Best answers
- Display two columns in data validation list but return only one - Guide
- Number to words in excel formula - Guide
- Student position formula in excel ✓ - Office Software Forum
- How to calculate position (1st,2nd,3rd) in excel....? - Excel Forum
- Calculation of positions in excel ✓ - Excel Forum
12 responses
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
May 28, 2009 at 02:27 AM
May 28, 2009 at 02:27 AM
Hi
Use the formula (in cell D1) =VLOOKUP(A1,$B$1:$C$9,2,FALSE)
Do let me know If it helps...
Use the formula (in cell D1) =VLOOKUP(A1,$B$1:$C$9,2,FALSE)
Do let me know If it helps...
May 29, 2009 at 01:15 PM
Thanks!
Apr 26, 2010 at 03:52 AM
Keep up the good work
Jul 19, 2013 at 12:14 PM
Oct 10, 2013 at 10:39 AM
Nov 7, 2013 at 12:22 AM