vlookup

  • Thread starter Thread starter sandra
  • Start date Start date
Sandra,

It has to return it to the same cell, or it can't be anywhere else. But that
cell can be anywhere on the sheet, or even some other sheet.

Is that what you mean?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
No, what I'm wondering is if I look something up from
book A in book B, do I have to send back the info in book
B to the same row in book A. Does that make sense?
 
Hi Sandra
also not quite sure but you can put your VLOKUP formula in any cell in
Book A where you want. It will return the results from Book B exactly
to this cell (regardless of the row)
e.g. put this in cell A1
=VLOOKUP("some value",'[bookb.xls]sheet1'!A1:B20,2,0)
even if this finds the value 'some value' in row 10, no problem with
that
 
Aha! Now Bob's response makes sense. When I did a search
I must've gotten a bunch of programming posts because I
got real confused real fast.

Thanks to both for taking the time to reply to a newbie!
-----Original Message-----
Hi Sandra
also not quite sure but you can put your VLOKUP formula in any cell in
Book A where you want. It will return the results from Book B exactly
to this cell (regardless of the row)
e.g. put this in cell A1
=VLOOKUP("some value",'[bookb.xls]sheet1'!A1:B20,2,0)
even if this finds the value 'some value' in row 10, no problem with
that

--
Regards
Frank Kabel
Frankfurt, Germany
No, what I'm wondering is if I look something up from
book A in book B, do I have to send back the info in book
B to the same row in book A. Does that make sense?
Click to expand...
some other
sheet.
.
Click to expand...
 
Sandra, a formula can only *pull* data back to itself in the cell that the
formula resides in. It cannot *push* data into any other cell - For that you
need VBA, OR you need a formula in the cell you were wanting to *push* the data
to, that will bring back the value for you.
 
Back
Top