Future in Hands club     Office Productivity     Microsoft Office     Microsoft Excel     Microsoft Excel Stuffs     Ask Excel Question    Formula Vlookup questions
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Vlookup questions
Amitg9595
Lots of things to do

Fresher
Joined: Aug 2018
Posts: 14

Reputation: 15

Location: Ghaziabad
#1
Thumbs Up  27-Sep-2018, 04:26 PM
Hi All,

PFA and find the solution.




Amit Kumar
9958639864


Attached Files
.xlsx   Vlookupquest.xlsx (Size: 15.2 KB / Downloads: 20)
  Find
  Reply
devendra_dev20
Lets begin to rock

Beginner
Joined: Apr 2018
Posts: 44

Reputation: 40
#2
06-Oct-2018, 07:35 PM
(27-Sep-2018, 04:26 PM)Amitg9595 Wrote: Hi All,

PFA and find the solution.




Amit Kumar
9958639864

Hi,

Please find the resolved attachment..

=IFERROR(IFERROR(VLOOKUP($A2,Data1!$A$2:$D$16,COLUMN(B1),0),VLOOKUP($A2,Data2!$A$2:$D$14,COLUMN(B1),0)),VLOOKUP($A2,Data3!$A$2:$D$9,COLUMN(B1),0))


Thanks


Attached Files
.xlsx   Vlookupquest_Resolved.xlsx (Size: 18.13 KB / Downloads: 8)
  Find
  Reply


Related Topics
Topic Author Replies Views Last Post
Special-offer Formula vlookup virendra 1 2,094 18-Nov-2019, 04:44 PM
Last Post: Chetan@FIH
  Formula VLOOKUP sukhwantsingh23 3 2,796 15-Nov-2019, 09:44 PM
Last Post: Chetan@FIH
  Formula If with vlookup for time ( HH:MM:SS) Amit5210 0 1,563 06-Jun-2019, 05:54 PM
Last Post: Amit5210
  Formula MULTIPLE QUESTIONS virendra 2 2,133 04-May-2019, 09:50 PM
Last Post: virendra
  Formula Vlookup Issue Jyoti 1 2,161 06-Mar-2019, 02:58 PM
Last Post: Vivekananda Sinha
  Formula Vlookup Rehman234 1 2,061 30-Dec-2018, 04:06 PM
Last Post: rawat7838
  Data Filtering Vlookup With Rank @m!t $@!n! 1 2,323 10-Nov-2018, 05:02 PM
Last Post: Vivekananda Sinha
  Formula Vlookup Query @m!t $@!n! 5 4,000 08-Nov-2018, 06:45 AM
Last Post: @m!t $@!n!
  Formula VLookup Related Question Aman Kumar 3 3,281 29-Oct-2018, 08:07 PM
Last Post: Vivekananda Sinha
  Formula Vlookup Skills Amitg9595 2 2,560 21-Oct-2018, 08:07 PM
Last Post: devendra_dev20
  Formula VLOOKUP formula Deepaksingh 3 3,698 29-Aug-2018, 07:43 PM
Last Post: Deepaksingh
  Data Filtering Query: Vlookup: Extract Number From Data @m!t $@!n! 3 3,736 10-Aug-2018, 10:53 PM
Last Post: @m!t $@!n!
  Formula Query: Vlookup: Exact Result Not Found @m!t $@!n! 3 3,267 02-Aug-2018, 03:30 PM
Last Post: Shiva Bairwa
  Formula Query related to VLOOKUP sanjeevdba 1 2,357 27-May-2018, 06:07 PM
Last Post: Amit5210
  Formula Difference between VLOOKUP 1D, 2D, 3D Hariom 1 2,967 17-Feb-2018, 09:07 AM
Last Post: Vivekananda Sinha

Forum Jump:


Users browsing this topic: 1 Guest(s)