Hello--

I have a formula entered as follows:

'=VLOOKUP(A8,Sheet1!$B$22:$O$22,2,FALSE)

My Sheet 1 - match column is this:

Row Column B
22 Store 1 - Primary
23 Store 1 - Secondary

I'd like to automatically have Vlookup return the values from Sheet 1, in
Row 23 without having to type that label in my original sheet, cell A9. Is
there any quick way to do this?

Thanks!!