Please attach a sample workbook with expected out which will be helpful to us for giving solution for your query.
Please attach a sample workbook with expected out which will be helpful to us for giving solution for your query.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Hi, srolash,
have you tried the functions VLookUp or Index/Match to solve your problem (please note that the search ranges should be absolute when filling down the formula)? From what has been written I doubt a mcaro to be necessary.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Dear Holger,
Yes I have tried these functions, but since I'm not a big expert in excel, I did not know how to write their syntax correctly, and this yielded error
If you know how to use them, I would be more than glad if you could show me.
Ciao,
srolash
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks