Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-27-2017, 09:28 AM
prnambiar prnambiar is offline Not able to find right Vlookup formula Windows 7 32bit Not able to find right Vlookup formula Office 2010 32bit
Novice
Not able to find right Vlookup formula
 
Join Date: Mar 2017
Posts: 2
prnambiar is on a distinguished road
Smile Not able to find right Vlookup formula

Dear Friends,



I am not able to find a proper formula to fetch some data that is required from another table and to be inserted in a series of columns

Appreciate your valuable advise to solve the problem

Thanks
Pranil
Attached Files
File Type: xlsx Help on Formula.xlsx (11.4 KB, 15 views)
Reply With Quote
  #2  
Old 03-27-2017, 01:25 PM
GIFCoach.com GIFCoach.com is offline Not able to find right Vlookup formula Windows 10 Not able to find right Vlookup formula Office 2016
Novice
 
Join Date: Mar 2017
Posts: 4
GIFCoach.com is on a distinguished road
Default

Hi,

For this I recommend using concatenate along with index match formula:

1. Create a new column in column A, then in A4 use formula =Concatenate(B4, C4). Then copy this down for all of the data

2. You can then reference this in your output table. For example in cell B31 use "=INDEX($I$4:$I$25, MATCH($B31&"|"&C$30, $A$4:$A$25, 0)). Then copy this for all the cells in your output table

3. You can use =IFERROR([Step 2 formula], "") around this formula if you want to replace error messages with blanks

4. To count up the total non-blank cells you can use for example in your first row =COUNTA(C31:E31)-COUNTBLANK(C31:E31)

(Note also that because you have two instances of 1056M on 1st March - it will pick up the first instance and not the second)

I've created a similar GIFCoach for this here (using changed data):


https://www.gifcoach.com/how-to/spli...ng-indexmatch/




Reply With Quote
  #3  
Old 03-29-2017, 02:23 AM
prnambiar prnambiar is offline Not able to find right Vlookup formula Windows 7 32bit Not able to find right Vlookup formula Office 2010 32bit
Novice
Not able to find right Vlookup formula
 
Join Date: Mar 2017
Posts: 2
prnambiar is on a distinguished road
Default Thanks for your help

Dear Sir,

Thanks a lot for your quick reply. Ive fixed the formula with the solution provided by you

Thanks
Pranil
Reply With Quote
Reply

Tags
help with formula

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Not able to find right Vlookup formula Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula innkeeper9 Excel 2 09-13-2016 08:59 PM
Not able to find right Vlookup formula Vlookup formula teza2k06 Excel 2 03-18-2014 01:21 PM
Not able to find right Vlookup formula I think I need an IF/AND & VLOOKUP formula here Catbert Excel 18 08-25-2013 07:38 PM
IF + VLOOKUP formula help skyline255 Excel 0 09-19-2012 05:05 PM
Help with VLOOKUP formula pattyr Excel 6 08-20-2012 02:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:37 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft