Return a value from a cell

[Al S]

Hi,

We have an online registration page for a volleyball tournament. The form allows the data to be downloaded as an excel file. The package selection (tournament they wish to play in) is allocated a number e.g. the Mens Open Tournament is allocated "763" when downloaded, unfortunately we cannot change the form as it is designed by a third party.

I have tried the IF function to read the cell, lets call the cell AC2, so the function reads the cell and returns "Mens Open" in the same cell as the function. However, the IF function has a limit of 7 nested functions and also reads the column and not just that specific cell.

Is there a way that i can have a formula that reads each cell and returns the value based on the cell content e.g. 763 would return "Mens Open", 764 would return "Womens Open", 767 would return "Coed Open" etc whether the cell contained 763, 764 or 767. The formula would then be copied down the column to return the package selection in a more readable format so it could then be sorted and eventualy printed.

Thanks for any help

Al

[Carim]

Hi,

A two step process :
1. Create the complete reference list
2. Use Vlookup() function to extract name from the reference list ...

[Al S]

Sorry i'm not understanding. I thought that VLookup read the entire column, i need to read each particular cell and have a return on its specific content, but there are 12 possible different package numbers requiring 12 specific returns. I'm not understanding the reference list either.

Thanks

Al