VLookup, multiple worksheets
Posted on 2012-03-29
I would like to grab numbers from column B in sheet1, find them on column B in sheet2, and report back the corresponding value in column D in sheet 2 to column C of sheet1.
Here is what I have been playing with in column C of row 25 on sheet1. Excel tells me there is an error, but I can't find what it is!
One more thing, columns A and C in sheet2 are hidden, so I don't know whether the 4 in my formula should be a 2 or not.