Formula problem

  • Thread starter Thread starter wmjenner
  • Start date Start date
W

wmjenner

What is wrong with this formula?

=VLOOKUP(INDIRECT("c"&ROW(2:2)),PullTo!$C$2:$Z$1100,9,FALSE)

The lookup is supposed to be from a worksheet called "PullTo" bu
instead it is returning the value from the worksheet the formula is in
What am I missing?

Thanks
 
Here is one I just tested on a workbook of mine. Worked fine.

=VLOOKUP(INDIRECT("A"&ROW(5:5)),yourworksheetname!a5:z20,3,FALSE)
This is what I was actually using that might help
=VLOOKUP(A5,INDIRECT("yourworksheetname!a5:z20"),3,FALSE)
 
Thanks Don. I just figured out that (as usual) this was a "user error.
Col. 9 in the lookup formula should have been Col. 10 (I had a colum
hidden that I didn't notice). I hate it when I do that
 
Back
Top