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...
I know that, but never mind...
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.
Indeed.