Hi all
Hope everybody is well.
I am currently trying to build a quote sheet that looks up values based on a quote number.
Example data sheet below, so I would add in the "1's" where I needed them:
And I am trying to get it to populate Column C with the "1" on a different tab, based on the number in Cell P1
So if I were to amend that number to in P1 "55", I would want the "1's" to appear in Test 1, Test 3 and Test 5.
I can index match, but can't seem to figure out how to do it!
All help appreciated.
Thanks in advance.
Hope everybody is well.
I am currently trying to build a quote sheet that looks up values based on a quote number.
Example data sheet below, so I would add in the "1's" where I needed them:
And I am trying to get it to populate Column C with the "1" on a different tab, based on the number in Cell P1
So if I were to amend that number to in P1 "55", I would want the "1's" to appear in Test 1, Test 3 and Test 5.
I can index match, but can't seem to figure out how to do it!
All help appreciated.
Thanks in advance.