ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Checking the lower row of vlookup() (https://www.excelbanter.com/excel-worksheet-functions/178618-checking-lower-row-vlookup.html)

ETLahrs

Checking the lower row of vlookup()
 
I am trying to see if there is a way to check a lower row after vlookup has
found the string in the first column. Example:

Year Event Length
1995 A 10
1995 B 56
1995 C 15

How would I search on another sheet to see if year "1995" had event "C", and
if so, display the length. This is a long spreadsheet with many items in the
first column and the second column isn't always in the number of entries.

Thanks For Any Info.
Edward




All times are GMT +1. The time now is 11:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com