Lookup function?

**wvpersephone13** · 06-10-2011, 09:12 AM

Hello. I am trying to make a spreadsheet where, when you enter a certain number in a cell, it references a chart and returns a certain value in another cell based on the number entered. The chart will be on the same Excel worksheet.

For example, based on the chart below, if I typed in "510" in cell A1, it should populate ".10" in cell A2.

NUMBER VALUE
500 .5
505 .7
510 .10
550 .15

I'm thinking this could be done using the Lookup function but I've never used it before. Any help would be most appreciated. Thanks!

**MarvinP** · 06-10-2011, 09:24 AM

Hi wvpersephone13,

See the attached with an example of VLookup.

**wvpersephone13** · 06-10-2011, 09:27 AM

Awesome! That looks like it's just what I need. Thank you SO much!

**kt090678** · 06-10-2011, 09:28 AM

hope the attached file should help you

**wvpersephone13** · 06-10-2011, 09:29 AM

Thanks kt090678!

**daddylonglegs** · 06-10-2011, 09:29 AM

What result would you expect if you typed in 520....or won't that happen?

**wvpersephone13** · 06-10-2011, 09:31 AM

There will only be certain numbers typed in. The sheet is for metal material codes, and it returns the metal's density. Good point though!

**TMShucks** · 06-10-2011, 09:33 AM

I think you'd probably call that a table rather than a chart but no worries. You want something like:

=VLOOKUP(A1,$D$1:$E$4,2,FALSE) ... if your table were in cells D1 to E4

Or, you could use:

=IFERROR(INDEX({0.5,0.7,0.1,0.15},MATCH(A1,{500,505,510,550},0)),"")

This probably works better if the values are static.

Regards