paramveer
Member
Please solve my problem in these link file
https://skydrive.live.com/redir?resid=FF9C73CAE52F48A2!127
https://skydrive.live.com/redir?resid=FF9C73CAE52F48A2!127
Vlookup type problem
- Thread starter paramveer
- Start date
SirJB7
Excel Rōnin
Hi, paramveer!
Next time please post here the issue description, keeping it into your workbook too if you consider it propertly.
This will help users who read this to decide whether they'd be able or want to analyze it further, without having to download/open any file.
Regards!
Next time please post here the issue description, keeping it into your workbook too if you consider it propertly.
This will help users who read this to decide whether they'd be able or want to analyze it further, without having to download/open any file.
Regards!
paramveer
Member
Hi bobhc : https://skydrive.live.com/redir?resid=FF9C73CAE52F48A2!127 this is link
Hi azumi : I check it your formula, I am unable to implement on my sheet
Hi Sir JB7 : Sorry next time i keep in mind
My problem is
When i use vlookup function Each time it copies first value from multiple same name value. So first problem is it repeat the first value everytime and Second question The formula may check itself how may instance same name value occur after giving the value it ruturn noting
Hi azumi : I check it your formula, I am unable to implement on my sheet
Hi Sir JB7 : Sorry next time i keep in mind
My problem is
When i use vlookup function Each time it copies first value from multiple same name value. So first problem is it repeat the first value everytime and Second question The formula may check itself how may instance same name value occur after giving the value it ruturn noting
SirJB7
Excel Rōnin
Hi, paramveer!
Azumi's solution seem to be working fine. He wrote in the worksheet that those were array formulas, but maybe omitted how to enter them, assuming that you were aware of that. If you select their cells you'll notice embracing curly brackets which denote that condition. They shouldn't be typed, but (array formulas) should be entered with Ctrl-Shift-Enter instead of just Enter.
Try this.
Regards!
Azumi's solution seem to be working fine. He wrote in the worksheet that those were array formulas, but maybe omitted how to enter them, assuming that you were aware of that. If you select their cells you'll notice embracing curly brackets which denote that condition. They shouldn't be typed, but (array formulas) should be entered with Ctrl-Shift-Enter instead of just Enter.
Try this.
Regards!
