I have 2sheets, sheet A and Sheet B, for Vlookup in excel-Sheet B i need unique id for that i need to concatenate multiple cells and Pivot the concatenated column so that if any duplicates that will be combined and will get desired output and now with this pivot output i have to lookup in Sheet A if it is found then that row should fill with Green color.
so in the above example column 4 is concatenated one using col 1,2,3 once done we need to create Pivot and with this Pivot will lookup in Sheet A if match found then should highlight in green In this case “C” is there in both sheets.
You need not pivot or create a concatenate
you can follow the steps
- Use excel file
- For each row in excel (SheetA)
- inside use For each row in Excel(SheetB)
- Inside the second for each use if codnition with
SheetAcurrentRow.ByField("Column1").StringValue = SheetBcurrentRow.ByField("Column1").StringValue and SheetAcurrentRow.ByField("Column2").StringValue = SheetBcurrentRow.ByField("Column2").StringValue and SheetAcurrentRow.ByField("Column3").StringValue = SheetBcurrentRow.ByField("Column3").StringValue
- On then side use format cell and give SheetAcurrentRow and in format select green color
Hope this helps
but @Anil_G in sheet B if have combination of 2 transactions which match transaction in sheet A then how to give that
It can match any number all the mactehs will be highlighted in green
my entire sheetA is highlighting in green.
What did you give in format cell can you please show some screenshots
Also you used full all conditions in if?
Is the data same as show in the first message?
If so then only last tow would be highlighted with the given conditions