vlookup

[sandra]

Hi,
Does vlookup *have to* return info to the same row? Yes
or No.

Thanks!

 

[Bob Phillips]

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)

 

[sandra]

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?

 

[Frank Kabel]

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

 

[sandra]

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?

some other
sheet.
.

 

[Ken Wright]

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.