• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Populate table based on input value

T

Thomas Kuriakose

Active Member
Dear Sirs,

Kindly find attached a file with 2 sheets. One has details and the other is the summary.

On inputting value in Input cell, the complete table based on the input value should be filled.

I tried using vlookup, index, and row functions but failed.

Kindly help, and would like to know whether there are more than one method to carry out this,

thank you so much

with regards,
thomas
 

Attachments

  • Input Value result.xlsx
    22.1 KB · Views: 0
Dear Sir,

Thank you so so much for this solution provided. You are awesome. Thanks so much once again.

Just for my learning, can we use vlookup or any function other than index, indirect to get the same result. Kindly show me this.

Thanks,

with regards,
thomas
 
Dear Sir,

Thank you so much for giving another insight into this.

just out my eagerness, can we use vlookup for this.

Thanks once again.

with regards,
thomas
 
jayalaxmi said:
hey somendra I liked the idea of urs bt can u pls explain this thing ROWS(A$10:A10)) in the formula to me...

Regards,
Jaya
Click to expand...

Hi Jaya,

ROWS(A$10:A10)) will populate sequence like as 1,2,3.... when dragging down.

On dragging below it will convert like as

ROWS(A$10:A11))
ROWS(A$10:A12))
ROWS(A$10:A13))
ROWS(A$10:A14))

So that will get...

ROWS(A$10:A11)) = 11-10 +1 =2
ROWS(A$10:A12)) = 11-10 +1 =3
ROWS(A$10:A13)) = 11-10 +1 =4
ROWS(A$10:A14)) = 11-10 +1 =5
 
Dear Sirs,

Sorry to trouble you.

I tried using Vlookup and chooe for the above and failed to get the result.

=VLOOKUP(A9,CHOOSE(B7,Contractual[#All],FullTime[#All]),1,FALSE)

Kindly let me know why this is not working.

Thank you so much.

with regards,
thomas
 
Dear Thomas,

I think there is misunderstanding on VLOOKUP usage. Go through it's documentation on Excel Help or visit any site for getting to know how VLOOKUP works.

Regards,
 
Dear Sir,

I read and noted the following -

Vlookup(What, Where, Column reference, false)

=VLOOKUP(B7,Contractual,1,FALSE), this is giving me #N/A. how to get the correct values for the table fill using Vlookup, choose, indirect, rows and columns.

Kindly help.

thanks,

with regards,
thomas
 
Dear Sirs,

Apologies for troubling, kindly help me with the vlookup option for this table fill.

The functions to be used are vlookup, choose,undirect index, rows and columns for this option.

thank you so much.

with regards,
thoms
 
With the type of input value VLOOKUP can not be used. INDEX is one option.
If the input value would have been a name with number than you could have got other information of that particular input name.

Regards,
 
Dear Sir,

Thank you so much for this clarification.

I was trying to use lookup and choose (could not apply, indirect, index, rows and columns) and it has not worked out after changing the reference in B7

Thank you so much once again.

with regards,
thomas
 

Attachments

  • Input Value result -2.xlsx
    22.1 KB · Views: 0
Dear Sir,

Thank you so much for the solution provided and the much needed support to complete this.

Thank you once again. Your are awesome.

with regards,
thomas
 
You must log in or register to reply here.
Back
Top