Enter a specific value.

[AlbertaTerry]

I have a question about entering a particular value in a cell. I have the following worksheet:



In Cell Q7 (and subsequent rows in column Q), I want to scan Column B, find the value that matches Cell M7, then move along that row to Column I, and enter that value.

In Cell Q6, I used the OFFSET function =OFFSET(I6,7,0,1,1) but that only iterates by one row when I fill it down. To work, I need it to iterate by 7 rows.

Can anyone help me out?

 

[Eric W]

Try this in Q7:

=VLOOKUP(M7,$B$4:$I$1000,8,0)

 

[AlbertaTerry]

Hello Eric - that is perfect! Thank you very much. I'm going to try figuring out why it's perfect; if I can't figure it out, I might have to ask you. Thank you once again.
Regards from Terry.

(I will also make note of the xl2bb tool)

 

[Eric W]

You could have used a variation of the OFFSET you first tried, but I think the VLOOKUP makes more sense. By all means, let us know if you have follow-up questions.

As far as the XL2BB tool, it's a huge help for the helpers here, and you'll likely get quicker responses if you use it.

Anyway, glad I could help and good luck!