Forum Discussion
Use a cell value for the row number in Vlookup.
On sheet 1 in row 5 and column h for example the formula, =IFERROR(-VLOOKUP('Sheet 3'!E13,Sheet2!A:K,6,FALSE),0) However I would like to replace the number in E13, with a value derived from ce...
Hi Hans,
The key difference is the punctuation around the name of the tab.
e.g 'Tab Name'
The key difference is the punctuation around the name of the tab.
e.g 'Tab Name'
I know that, but never mind...
Indeed.
- Hans, you couldn't have known because Flow2's original post didn't use ' around Sheet2 but did use it around 'Sheet 3' so it would appear his Sheet2 name didn't have a space ... but then later it did.
