Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
vlookup -- Upper case and Lower case text | Excel Discussion (Misc queries) | |||
VLookup - Error Checking | Excel Discussion (Misc queries) | |||
Using COUNTIF and VLOOKUP with upper and lower case letters | Excel Worksheet Functions | |||
need to select closest match using vlookup if it higher or lower | Excel Discussion (Misc queries) |