I use a formula =HLOOKUP(F1,BRS!6:7,1,FALSE)
If this formula gives me a value from cell F3 of sheet"BRS", how can I change same formula so that it shows me value of E3, instead of F3.
In other words I want to get value of previous column of Row3 based on Hlookup of any value in Row2. So if Hlookup value is in Column F of Row 2 the formula should give the result from Column E of Row 3.
Thanks
Bookmarks