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
 - How to delete a column in word - Guide
 - Display two columns in data validation list but return only one - Guide
 - Tweetdeck expand column - Guide
 - Excel count occurrences of string in column - Guide
 - Excel column to number - 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)