i have a table in sheet 1,
the left hand column is a date and the right hand column is a list of sequenial numbers
i need a vlookup to find the first blank cell in the first column and display the number next to it
Date Po Number
07/10/11 1
15/10/11 2
10/11/11 3
........... 4
........... 5
the forumula will show 4
the left hand column is a date and the right hand column is a list of sequenial numbers
i need a vlookup to find the first blank cell in the first column and display the number next to it
Date Po Number
07/10/11 1
15/10/11 2
10/11/11 3
........... 4
........... 5
the forumula will show 4