Vlookup Formula Range is F:E and want result

[HaroonSid]

hello
i want to use vlookup to range("F:E")

formula is in Cell B1

Please Login or Register  to view this content.

e.g Cell A1=7, Sheets("ENTRY").Range("E")= 7, and Sheets("ENTRY").Range("F")= Bahr then

result should be = Bahr

[Winon]

Hello haroon2015,

Try, =VLOOKUP(A1,Entry!E:F,2,0)

Regards

[HaroonSid]

HELLO Winon
I WANT TO USE LIKE BELOW

Please Login or Register  to view this content.

[Winon]

Hello haroon2015,

Sorry, I do not understand your problem because it works on my side. Maybe your Workbook is setup differently.

Please attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Thank you.

[HaHoBe]

Hi, haroon2015,

by default VLookup will search the item in the most left located column of the matrix and expects this Matrix for search to be addressed correctly from the left to the right (if the standard direction is from left to right). No chance for what you want - it should not be compatible to the parameters expected by WorksheetFunction VLookup.

Ciao,
Holger

[sktneer]

I think you are trying for Reverse Vlookup. Use Index/Match rather if that is the case.

[HaroonSid]

yes sktneer ur right i want to reverse the code
plz write the code

[HaHoBe]

Hi, haroon,

e.g Cell A1=7, Sheets("ENTRY").Range("E")= 7, and Sheets("ENTRY").Range("F")= Bahr then

result should be = Bahr

Strange description of your problem after what your posted in #7.

Ciao,
Holger

[Winon]

haroon2015,

Please see Post#4, how could you expect anyone to "Write you some formulae", without seeing what your exact requirements are.?

[HaroonSid]

Hello Winon

u gave me this code

Please Login or Register  to view this content.

now using of index or match function reverse the code

Please Login or Register  to view this content.

or i will upload the sample file

[HaHoBe]

Hi,

Please Login or Register  to view this content.

Ciao,
Holger

[Winon]

@ HaHoBe,

Strange description of your problem after what your posted in #7.

Please tell me how long is a piece of string.

Ciao.

[HaroonSid]

HaHaHa!

HoHoBe u r the man............thanx alot working perfect as i want

thanx a lot my dear

[HaroonSid]

Hello Winon

sorry for i m not able to write down the right description of my requirement, because of that english is not my native language and i m week in english....so plz so sorry again....

i know u will give right solution when u will understand the problem


BTW thanx alot all of u to reply