I have a table with several negative numbers scattered on it, I want to do a lookup that would show the negative amount on that specific column. So I tried to mix vlookup with hlookup but it is not working correctly. Here is the formula I used:
=VLOOKUP($B$3,Sheet1!$A:$BD,HLOOKUP(Sheet1!B1,Sheet1!$B:$BD,2),FALSE)