Looking up a dollar amount between two column
Closed
Dana
-
May 17, 2010 at 04:57 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 17, 2010 at 05:36 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 17, 2010 at 05:36 PM
Related:
- Looking up a dollar amount between two column
- Display two columns in data validation list but return only one - Guide
- Is the 500 dollar shein gift card real - Guide
- How to delete column in word - Guide
- Tweetdeck remove column - Guide
- Excel count occurrences of string in column - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 17, 2010 at 05:36 PM
May 17, 2010 at 05:36 PM
use vlookup
=VLOOKUP(14,A:A,1,TRUE)
this looks for value in column A and returns the exact value being matched (14 in this case) or the less than it
=VLOOKUP(D2,A:A,1,TRUE)
=VLOOKUP(14,A:A,1,TRUE)
this looks for value in column A and returns the exact value being matched (14 in this case) or the less than it
=VLOOKUP(D2,A:A,1,TRUE)