Hello, I am trying to get the value of a cell below a cell.
Exampe:
A1 = "1" B1 = "00134789"
A2 = B2 = "20X1102"
A2 contains no data, I can get the B1 data with the VLOOKUP but can't get the B2 data. My data is sorted by Column A....is there a command I can put in a formula to get the data below a cell?
Thanks
Bookmarks