How lookup numbers between range numbers in 1 cell ?

**termal** · 02-02-2010, 04:32 PM

Hi

please download my attach file .

I want lookup"7 or other range numbers" in column "Number" simultaneous lookup "A" or "B" or "C" in column "Column" , What should i do now ?

THX
2010

**teylyn** · 02-02-2010, 04:36 PM

Hi,

change the values in column A to
4
7
10

and then use

=VLOOKUP(7,A3:D8,2,TRUE)

**termal** · 02-04-2010, 01:41 PM

Thanks but i like any number in rang search,
it is means any number in range [1,>10]

and what i do ?

**teylyn** · 02-04-2010, 04:03 PM

Please don't quote wholes posts. That just creates clutter.

Your data sample started with 4 - 7. What shall be returned for values < 4?

Insert a row above the first, enter 1 in column A and your respective values in B to D.

Oh, and get rid of the merged cells. There is really no need form merging them. You could just make the rows higher.