Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Is it possible to get the data from right to left using vlookup?

user-image
Question added by Abdulrehman Mohammed , Training and Development Manager - Technical , Almarai Company
Date Posted: 2013/09/30
Zafar Iqbal
by Zafar Iqbal , Teacher (Pak Studies) Subject Specialist , Home Tutor

Yes it is quite possible.

Hadi Husaini
by Hadi Husaini , Senior Manager - Indirect Taxation , Biological E Ltd

As per my experience, Excel2007 - The data to be searched in the range will always return the value placed at the right of the column in which data is. It will not return value placed at left.

Abdulrehman Mohammed
by Abdulrehman Mohammed , Training and Development Manager - Technical , Almarai Company

Yes!! It is possible to get the data from left using Vlookup with other function. I did this and it is working very well.

More Questions Like This