Future in Hands club     Office Productivity     Microsoft Office     Microsoft Excel     Microsoft Excel Stuffs     Ask Excel Question    Formula V-lookup Question
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
V-lookup Question
Amit Rawat
Lets begin to rock

Beginner
Joined: May 2018
Posts: 32

Reputation: 0
#1
13-Oct-2018, 09:19 PM
Hi Sir,

I need your assistance to solve this 2 questions via Vlookup function only.

Please see the attachment.


Attached Files
.xlsx   Vlookup Question.xlsx (Size: 16.2 KB / Downloads: 21)
  Find
  Reply
Vivekananda Sinha
The next innovation

Mentor
Joined: Apr 2017
Posts: 590

Reputation: 0

Location: Delhi
#2
14-Oct-2018, 05:21 PM
Please find the attached solution.


Attached Files
.xlsx   Vlookup Question (2).xlsx (Size: 18 KB / Downloads: 19)
Regards,
Vivekananda Sinha

If you cannot change the way you learn, how can you change the way you earn.  Smile
  Website   Find
  Reply
devendra_dev20
Lets begin to rock

Beginner
Joined: Apr 2018
Posts: 44

Reputation: 40
#3
14-Oct-2018, 06:10 PM
(13-Oct-2018, 09:19 PM)Amit Rawat Wrote: Hi Sir,

I need your assistance to solve this 2 questions via Vlookup function only.

Please see the attachment.

Hi,

Please use below function.

=VLOOKUP("zzz",$A$1:A2,1)&"("&B2&")"

Thanks


Attached Files
.xlsx   Vlookup Question.xlsx (Size: 17.09 KB / Downloads: 8)
  Find
  Reply
Vivekananda Sinha
The next innovation

Mentor
Joined: Apr 2017
Posts: 590

Reputation: 0

Location: Delhi
#4
16-Oct-2018, 01:56 PM (This post was last modified: 16-Oct-2018, 01:58 PM by Vivekananda Sinha.)
(14-Oct-2018, 06:10 PM)devendra_dev20 Wrote:
(13-Oct-2018, 09:19 PM)Amit Rawat Wrote: Hi Sir,

I need your assistance to solve this 2 questions via Vlookup function only.

Please see the attachment.

Hi,

Please use below function.

=VLOOKUP("zzz",$A$1:A2,1)&"("&B2&")"

Thanks

This is the better one. VLOOKUP with Approximate match.  Wink.
I never thought this solution. Good one.
Regards,
Vivekananda Sinha

If you cannot change the way you learn, how can you change the way you earn.  Smile
  Website   Find
  Reply


Related Topics
Topic Author Replies Views Last Post
  Formula Interview Question Amit sharma 1 1,800 23-Apr-2019, 02:52 PM
Last Post: prashantbverma7@gmail.com
  Others Excel Question Amit sharma 3 2,856 17-Dec-2018, 12:04 PM
Last Post: Amit sharma
  Formula VLookup Related Question Aman Kumar 3 3,061 29-Oct-2018, 08:07 PM
Last Post: Vivekananda Sinha
  Formula Lookup Query @m!t $@!n! 1 2,211 29-Aug-2018, 12:19 PM
Last Post: devendra_dev20
  Formula Duplicate values Lookup formula in single time show Mohit Sharma 2 3,004 23-Jul-2018, 09:22 AM
Last Post: Mohit Sharma
Bestseller Formula Lookup query - based on multiple conditions Amit Rawat 2 2,944 16-Jul-2018, 05:05 PM
Last Post: Amit Rawat
Home Formula Question Jyoti 2 2,498 10-May-2018, 06:41 PM
Last Post: Jyoti
  Formula Lookup formula Praveen Kr. Gupta 7 5,318 03-Feb-2018, 04:31 PM
Last Post: ARUN SHARMA
  Formula Question related to formula ANJALI GUPTA 4 3,419 10-Nov-2017, 07:11 PM
Last Post: ANJALI GUPTA
  Formula Lookup data but have no unique value Dharmesh Kumar Srivastava 7 5,997 28-Sep-2017, 09:39 PM
Last Post: Lovedeep sharma
  Formula lOOKUP WITH MERGED CELL Dharmesh Kumar Srivastava 2 3,345 10-Aug-2017, 05:18 PM
Last Post: Dharmesh Kumar Srivastava
  Formula solve this question with choose Shiva Bairwa 3 3,731 24-Jul-2017, 12:32 PM
Last Post: Anil Kumar Pal
  Formula how to apply vlookup in case of different formats of lookup value Deepika Khanna 2 4,101 01-May-2017, 04:58 PM
Last Post: Deepika Khanna

Forum Jump:


Users browsing this topic: 1 Guest(s)