VLookup

[brin]

Hi
I think I need a VLookup but I don't really know.

I wan't to lookup the data column D and match the entry in Cell C5 (pink).
The BLUE D21 is the correct match.
Then I wan't to put the Min and Max from columns E and F into cells A5 and B5.

Any assistance would be appreciated.

Sheet1

	A	B	C	D	E	F
4	Min	Max	Range	Data	Min	Max
5	$500	$799	$500-$799	$300-$599	$300	$599
6				$250-$549	$250	$549
7				$200-$499	$200	$499
8				$150-$449	$150	$449
9				$100-$399	$100	$399
10				$350-$649	$350	$649
11				$300-$599	$300	$599
12				$250-$549	$250	$549
13				$200-$499	$200	$499
14				$150-$449	$150	$449
15				$450-$749	$450	$749
16				$400-$699	$400	$699
17				$350-$649	$350	$649
18				$300-$599	$300	$599
19				$250-$549	$250	$549
20				$550-$849	$550	$849
21				$500-$799	$500	$799
22				$450-$749	$450	$749
23				$400-$699	$400	$699
24				$350-$649	$350	$649

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[frank_AL]

If I am understanding you correctly Column C would already be populated and you want to find that value in the table and populate Min and Max in Columns A & B.
Enter this formula in cell A5: =VLOOKUP($C5,$D$5:$F$24,2,FALSE)
Enter this formula in cell B5: =VLOOKUP($C5,$D$5:$F$24,3,FALSE)
Then copy down for all Rows you want to evaluate.

 

[brin]

Fantastic.
Works well.
I didn't need to copy the formulas down columns A & B. This showed a #N/A
Many thanks.