How to use offset to concatenate a reference and a letter?

[wilsjohn]

Hi I want to look up a cell value based on "B" and A7 which contains a number so that the end result should be B23.

Im not quite sure how to do this although I believe you use offset.

so something like "B&a7"

thanks in advance for the help

 

[Special-K99]

=indirect("b"&a7)

 

[wilsjohn]

Thank you so much

 

[wilsjohn]

Quick Question,

How would you incorporate a worksheet name?


indirect(Data!"D"&b5:Data!"J"&c5)

best
John

 

[Special-K99]

Try

indirect("Data!D"&b5&":"&"J"&c5)

 

[wilsjohn]

thanks!!