Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 4th 09, 07:02 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2009
Posts: 1
Default how can i find a value in a range?

I'm trying to find a value from cell H2 that is in range a1:b38.
i,e: H2=1.3 but there's no equal value to it in the a1:b38 range, i'm
trying to get a value that is in the cell CXX depending on the row that can
contain the value of H2.

For more clearness the a1=0, b1 = 1.6 and c1=15. Due H2=1.3 and it is
contain between a1 and b1 (0 to 1.6) i'm trying to get the value in return
of C1 (15).

How can i do this? could you please reply to ?

  #2   Report Post  
Old July 4th 09, 07:08 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 11,501
Default how can i find a value in a range?

Hi,

Try this

=VLOOKUP(H2,A1:C17,3)

Mike

"mannymtz" wrote:

I'm trying to find a value from cell H2 that is in range a1:b38.
i,e: H2=1.3 but there's no equal value to it in the a1:b38 range, i'm
trying to get a value that is in the cell CXX depending on the row that can
contain the value of H2.

For more clearness the a1=0, b1 = 1.6 and c1=15. Due H2=1.3 and it is
contain between a1 and b1 (0 to 1.6) i'm trying to get the value in return
of C1 (15).

How can i do this? could you please reply to ?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find %ontime & SUMIF ontime ie: find matching sets within Range... Chris T-M Excel Worksheet Functions 3 October 10th 08 08:14 PM
Find the MAX number in range, then find... pgarcia Excel Discussion (Misc queries) 4 September 19th 08 06:58 PM
how do I find the last value of a range.... Kath Excel Worksheet Functions 9 June 12th 08 03:07 PM
Find a range of values in a range of cells Jack Taylor Excel Worksheet Functions 20 November 25th 06 02:26 PM
Find dates in a range; then sum values in that range by a criteria Anders Excel Discussion (Misc queries) 4 October 21st 05 03:41 PM


All times are GMT +1. The time now is 06:43 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017