More formula
Closed
Suresh
-
Nov 19, 2009 at 11:27 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 20, 2009 at 06:01 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 20, 2009 at 06:01 AM
Related:
- More formula
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Credit summation formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 20, 2009 at 06:01 AM
Nov 20, 2009 at 06:01 AM
in B2 copy paste this formula
=VLOOKUP(A1,$H$15:$I$20,2,FALSE)
copy B2 down
At first the colum B will show only #N/A
but once you enter sme number like 1,2 etc you will get the correct description in the adjacent cell
=VLOOKUP(A1,$H$15:$I$20,2,FALSE)
copy B2 down
At first the colum B will show only #N/A
but once you enter sme number like 1,2 etc you will get the correct description in the adjacent cell
