Forum Discussion
vlookup problem
thanks for help
but i am a new user for excel i am now using vlookup function to get data
can you send formula with only vlookup function excluding iferror or index i am not familiar with these functions yet
but i am a new user for excel i am now using vlookup function to get data
can you send formula with only vlookup function excluding iferror or index i am not familiar with these functions yet
and why i have to shift column b to a
In VLookup function, the lookup value should be in the first column in the table_array which is not the case with the data. The lookup value ID# exists in column C and you want to fetch the Names which are in column A, therefore VLookup will not work in this case.
Though for fetching values from Comp. Column D, you may use VLookup formula like this...
=VLOOKUP(J2,C:D,2,FALSE)
I have placed the above formula in column L for your reference.
The above formula works because the lookup value J2 exists in the first column of the table_array C:D and it is fetching the values from a column which is right to the lookup column.
If your data is arranged like what is showed on the VLookup Sheet (redTab), you may use the VLookup function without any issue.
There is nothing wrong in learning about Index/Match function, they are more flexible and easy to implement once you learn about how to use them.
- THANKS IT IS CLEAR APPRECIATION FOR YOUR HELP
You're welcome! Glad I could help.
If that takes care of your original question, please take a minute to accept the post with the proposed solution as a Best Response/Answer to mark your question as Solved.
