Hi I need to determine if a certain range has text. this range is adjacent to vlookup value.Test Data.xlsx
In want to refer to the row above any cell in E36:K42 by using vlookup with the number above in row 34 to look
in column D and returning the adjacent range.
Bookmarks