Ask Your Question

007Charlette's profile - activity

2019-10-05 13:15:11 +0200 received badge  Famous Question (source)
2019-06-20 14:18:49 +0200 received badge  Notable Question (source)
2019-06-20 14:18:49 +0200 received badge  Popular Question (source)
2019-06-18 23:35:56 +0200 marked best answer I need help in creating a lookup formula from my chart.

So far I have tried to enter my data as a vertical table for length and weight. These are set whole numbers. I did another table for the weight distributions with percentages and the results I have calculated. I am stuck on the simple starting point of having my list recognize the predetermined weights chosen via a drop down option.

I keep getting this error code---508 ---My sheet info is attached--- I have tried a Vlookup =VLOOKUP(Info.A3:a12l,Info.B3:B12,3,0) i think this was the last formula used, i have used so many that were wrong on my end i can't even see straight.

I have attached my file that i am trying to do C:\fakepath\Example.ods

2019-06-18 23:35:56 +0200 received badge  Scholar (source)
2019-06-18 23:30:15 +0200 commented answer I need help in creating a lookup formula from my chart.

Thank you! It is fixed!! The last message you sent, I redid and it works.It is fixed. Thank you so much.

2019-06-18 23:22:15 +0200 commented answer I need help in creating a lookup formula from my chart.

sorry that { } appeared because i used alt, up arrow and shift to enter the vlookup.. I went and typed it as is and pr

2019-06-18 23:21:23 +0200 commented answer I need help in creating a lookup formula from my chart.

sorry that { } appeared because i used alt, up arrow and shift to enter the vlookup.. I went and typed it as is and pr

2019-06-18 22:25:40 +0200 edited question I need help in creating a lookup formula from my chart.

I need help in creating a lookup formula from my chart. So far I have tried to enter my data as a vertical table for len

2019-06-18 22:20:25 +0200 commented answer I need help in creating a lookup formula from my chart.

now it is back to showing an error 508

2019-06-18 20:01:45 +0200 commented answer I need help in creating a lookup formula from my chart.

it is showing an #N/A now which beats a 508 i suppose. I have updated my original to include the spreadsheet part and t

2019-06-18 18:29:12 +0200 asked a question I need help in creating a lookup formula from my chart.

I need help in creating a lookup formula from my chart. So far I have tried to enter my data as a vertical table for len