Its all gone apples and pears!!! VLookUp problem???

[Watsoa]

Hi guys,

I want to perform a lookup function that will find a given value within a range. Ie: A1:B12

Column 1 being a list of fruit.
Column 2 being the price of that fruit.

Upon inputting "Banana" the user will be told the price of a banana in cell D4 (can do with a standard vlookup)...but I also need to retrieve name of a fruit that is within a certain price range from the cost of a banana in D5(say 15cents/pence whatever the currency)

So if banana = 40, apple = 28, mango = 60 then D4 will display "40" and D5 should display "apple"

Ive just started getting to grips with VBA so any help would be brilliant.

Thanks
A

 

[Aladin Akyurek]

Try to be complete: Put up the whole fruit table A1:B12.

Specify where you enter the fruit "banana" for which you want the price in D4.

Also, specify exactly the plus/minus value...

 

[Watsoa]

Aladin to my rescue again. Ive replied to your previous post...this one was me trying to elaborate as reading that post back i dont think id posted enough detail just as you point out.
Hope it reads more easily now?

Thanks

 

[Jon von der Heyden]

Please refer to your original thread: http://www.mrexcel.com/forum/showthread.php?t=533245

You seem to be firing out the same question over and over. I just can't work out the motive. Each has attracted attention from capable and regular members. Please pursue only your original.

Per the forum rules, threads of duplicate nature will be locked or deleted.