Comparing columns and returning value
Solved/Closed
Related:
- Compare 2 text cells and show difference in the third cell
- Excel match two columns and output third - Best answers
- 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
- Tentacle locker 2 - Download - Adult games
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Five nights in anime 2 - Download - Adult games
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - 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