#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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/ |
#3
|
|||
|
|||
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 |
Tags |
help with formula |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
Vlookup formula | teza2k06 | Excel | 2 | 03-18-2014 01:21 PM |
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 |