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
- Download mp3 with lyrics display - Download - Audio playback
- Huawei display check code - Guide
- Laptop fan on but no display - Guide
- To display a text file in reverse order what command should be used - Guide
- How to display contact name and number in android - 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.
