# Posts by jacjas

• ## return a value in one cell based on part of the data in another cell

Re: return a value in one cell based on part of the data in another cell

i have used your original formula changed the cell references and hidden the columns worked brilliantly thank you, what was the name of that formula ? i am a novice but love learning thx again for all your help

• ## return a value in one cell based on part of the data in another cell

Re: return a value in one cell based on part of the data in another cell

ive done it using your original formula thank you so much, i had to change some of the references to fit with the master sheet i have but have got there and then hidden the columns so other users cant edit it, thanks again, does that formula have a name ? i am a novice but love learning

• ## return a value in one cell based on part of the data in another cell

Re: return a value in one cell based on part of the data in another cell

hi yes it is i dont know where to put that table of data can it go on another workbook ? and does it matter that the TG codes are in a random order in column A ?

• ## return a value in one cell based on part of the data in another cell

Re: return a value in one cell based on part of the data in another cell

hi thats great and it works thank you but is there anyway this can be done using a nested If function ?

• ## return a value in one cell based on part of the data in another cell

Re: return a value in one cell based on part of the data in another cell

• ## return a value in one cell based on part of the data in another cell

Re: return a value in one cell based on part of the data in another cell

i can upload a file if that helps

• ## return a value in one cell based on part of the data in another cell

Re: return a value in one cell based on part of the data in another cell

its a list one per cell in a column thx

• ## return a value in one cell based on part of the data in another cell

i have a column of data part number part text e.g 7w1,8b1 in the next column i want to write a function that will look at the other and dependant on whats in it place a word e.g. for 8b1 i need it to look at the "b" and enter beauvale if theres no "b" but a "w" enter wollaton, please can anyone help? i have tried an if function and used "*b*" but it doesnt seem to like wildcards ....

any help greatly appreciated

• ## populate a cell using twO results from the same table & referring to another table

Re: populate a cell using twO results from the same table &amp; referring to another tabl

Thank you so much i have been pondering this for days but i am a novice so was really struggling, thank you danerida. I obviously need to learn more about the two said formulas index and match so i can understand how these work.

• ## populate a cell using twO results from the same table & referring to another table

Re: populate a cell using twO results from the same table &amp; referring to another tabl

i think i have managed to attach the file, and thank you

• ## populate a cell using twO results from the same table & referring to another table

Hi

I have a workbook with two worksheets,

sheet 1 contains student data, name dob, actual age, raw score and an empty column standardized score

sheet 2 contains a conversion table, using the actual age from sheet one you locate the age in the top row of table in sheet 2, and using the raw score from sheet 1 you locate the matching raw score from the first column of the table in sheet 2, going down and acrosss until you meet this gives you a standardised score

i want the standardized column in sheet one to fill by using a formula which looks at the table in sheet two locates the two values and returns the result.

is that possible?

i can attach files if necessary