G
Guest
In Cell D1 if I am looking up the contents of a cell C1 (in this case the
name "bill") in the range A1:B10 and "Bill" is found in B2. Why is it that
if I ask for 1 to be returned I get an #n/a message.
D1 =vlookup(C1,A1:B10,1,false)
Why doesn't this work and is there a way to correct the problem?
Thank You
Brian
name "bill") in the range A1:B10 and "Bill" is found in B2. Why is it that
if I ask for 1 to be returned I get an #n/a message.
D1 =vlookup(C1,A1:B10,1,false)
Why doesn't this work and is there a way to correct the problem?
Thank You
Brian