Section Number Search from Horizontal Cabin Numbers

[nutrastat]

Hi, I cannot think how to do a horizontal search to find a Section Number (Cabin 15001) and hope you are able to help me?

The stats screenshot, I would like to be able to add the Section number for 15001, but cannot for the life of me work out how to do it for all cabins for each section.

Can somebody please help?

 

[mole999]

did you look at HLOOKUP?

graphics don't show when linked to your own PC

 

[nutrastat]

did you look at HLOOKUP?

graphics don't show when linked to your own PC

So I found out about the graphics!

The problem with HLOOKUP is that I do NOT have the Section Name (i.e. I only have the Cabin number) and need to find the Section Name. In this instance, it is reversed, I am looking for a cabin number, to find the Section Name, otherwise I could do an HLOOKUP without difficulties.

Thanks for your help & comment.

 

[mole999]

using an html tool can you show a small example of what you have