Lookup woes

[myheadhurts]

Have been struggling with a problem for a few hours now

I've attached a small sample of part of my sheet. I'm trying to put a function in cell AV4 to look in range B4:AT4 for a "v", If there is one to return the contents of the cell in range B3:AT3 which is in the same position in the row, but if there is no "v" return nothing.

Book1.zip

I then need AW4, AX4, AY4, and AZ4 to do the same but looking for "w", "x", "y" and "z" respectively, and I then need to do the same for each row (366 rows in total) but the result is always B3:AT3.

I have the additional problem of what if, for example there is more than one "v" in a row, but until I sort this first part I can't even think how to do that.

I've been experimenting with the IF, HLOOKUP and now LOOKUP, and I've used a COUNTBLANK to give me nothing if there is no entry in the row but I might just be confusing myself.

As you can see from my sample the result I'm getting is always Z9 instead of the result which corresponds to the position of the entry.

Hope someone can help while I've got some hair left

myheadhurts

[NBVC]

Try this formula in AV4 copied down and across the table:

Please Login or Register  to view this content.

[myheadhurts]

Perfect, thats absolutely brilliant, many many thanks