Vlook Up with >= <= <

I have an Excel Sheet Which contains values in A Coloumn (Iam Attaching The sheet). In The Next sheet I have conditions for Example if The Value in A Coloumn is >= 100 (hunders) then it should show A against to A column means In B Coloumn, if it less then <75 and > 25 it should show B and other It the value is less then < 25 or= it should show C.

I did this actually with a simple vlookup formula but it is not coming Now.

Regards,
VAJEEDAttachment 262788

Here, try this:

Formula:

Please Login or Register  to view this content.

Superb !!!!!! Both THe Answers Are correct, I have done in other way. with Vlookup Range ,,,,,
But Hats off to you both........ MVP

It is vero good that we post a problem and we get reply in no time. I appreiciate your time and the efforts. Mvp

Hi,
Once again I Have Problem I want to Copy Sheet2 data coloumn A : A to Sheet1 Coloum B through VBA and Zeros Should Not Come, I don't No VBA Operating But Still I want To Do that.I no Only ABCD In VB. Can You please help me. My Workbook Name is : test

Dear Sir,

I would like to Copy The (Sheet 2 Column A) to (Shee1 Column B) in the Same Workbook named Test through VBA, And I need not see Zero Values, Like This I have 4 to 5 Columns In Sheet 2.

And This should be done without any command button means Automatically in sheet1 the values should update.

Regards,
Vajeed