Vlookup, fixed value with a loop funcion

[snewell]

On sheet SPC DATA COLLECTION_Master starting in the cell labeled Balloon N7 stepping by 14 down to cell N276 I want to search thru 'Reference sheet A10: thru A383
if there is a "#" symbol i want to return the balloon number in the next column and continue to loop thru until I have found all of the "#" symbols

The result on the sample sheet would be on sheet SPC DATA COLLECTION_Master cell N7=2 N14=4 and N21= 8. When these numbers are entered other cells are populated with data from the Reference sheet

Thanks


Steve

[Jacc]

Just opened your file to have a look. I set column width to 6,43 for columns E:AN for no reason at all. On my laptop in a dark room that created a rather convincing optical illusion, took me several seconds to get that sorted, wow.
As for your actual question, I'll have another look now.

[snewell]

Hi Jacc,
Yup, that's a pretty busy workbook.
thanks for taking a look at it

Steve

[Jacc]

If you fill in a few lines of sample data and the expected results it will be much easier for me to help you.

[snewell]

Please see the attached file that has sample data
On sheet Reference sheet (edit here) I have added data in cells B10 to B15, also in cells A11, A12 and A14 I have eneter a "#" symbol

When SPC DATA COLLECTION_Master is opened I what the code to search thru sheet Reference sheet and where it sees a "#" symbol I want it to enter the Balloon number (B10 thru B383) in the cell
next to "Balloon" (N7,N21,n35, etc) on sheet SPC DATA COLLECTION_Master

so for this example it would fill in cell N7 with "2" N21 with "3" and N35 with "5". When these fields are populated there is code that brings in more data


Thanks


Steve