How to get vlookup to display without changin
Closed
PhilMac
-
Oct 19, 2009 at 03:48 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 19, 2009 at 08:53 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 19, 2009 at 08:53 PM
Related:
- How to get vlookup to display without changin
- Computer turns on but no display - Guide
- To display a text file in reverse order what command should be used - Guide
- Huawei display check code - Guide
- Internet explorer cannot display the webpage - Guide
- How to reset ps3 display settings - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 19, 2009 at 08:53 PM
Oct 19, 2009 at 08:53 PM
little confusing. your column heading A5 is like to be confused with cell A5(5th row 1st column ).
in the formula
=VLOOKUP(A5,$A$1:$A$9,2,FALSE))
what is A5 and what is 2.
what do you want to find.
in the vlookup formula the first argument must be the first column in the second argument reference range . Otherwise use index-match function.
in the formula
=VLOOKUP(A5,$A$1:$A$9,2,FALSE))
what is A5 and what is 2.
what do you want to find.
in the vlookup formula the first argument must be the first column in the second argument reference range . Otherwise use index-match function.
