RETURN VALUE OF ROW 1
 

Hi - me again, sorry but trying to think this out for myself

I am using =IFERROR(MATCH($W118,Z$2:Z$112,0),0)

for each of 5 formulae to split my customer postcode and check if there is a match in the Zone. So columns Z thru AT each represent 1 Zone called by letter A,B,C etc.

With my customer postcode of SN14 7BG in cell W118 I get to match the following;

SN14 7BG
SN14 7
SN14
SN
S

in this example I match SN in Zone A and S in Zone B - Naturally I need an exact match because S is for Sheffield over 100 miles away so I run another formula in a cell to prove an exact match and this gives me the following

SN14 7BG FALSE 0 0 0 0 0
SN14 7 FALSE 0 0 0 0 0
SN14 FALSE 0 0 0 0 0
SN TRUE 2 0 0 0 0
S FALSE 0 88 0 0 0

Where the value True then finds a row number in a column to the right of it I need to count up to row number 1 and return the Zone letter in that cell.

Not sure if the columns will show when I post this, but I hope its not too confusing

regards

Corporal Smudge