h-lookup

  1. Guzzlr

    H-Lookup to be dynamic

    Hello All; I'm using; =IFERROR(HLOOKUP(B$32,$19:$30,11,FALSE),"") The problem is the lookup ID of Row 11. Row 11 is looking at the name of Sam. If this name, Sam, moves, the H-Lookup no longer works. I've cured this problem using VBA to make it more dynamic, as Sam moves, Sam is still...
  2. B

    help with complciated vlookup + if formula

    would really appreciate any help...wish i could attach the excel document here as it'd be easier to describe, but essentially, this is what i need to happen in 5 different cells: Cell 1. If there is a "V#" (meaning v1, v2, V3, etc) in Column L, then take that "V#" Cell 2. For whichever row had...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top