V lookup

[jeff]

does anyone have any advice or a way to easily remember
how to compose this formula?

thanks

 

[George Nicholson]

lol, i got that question once in a phone interview for a job.


what to look for?, where to look for it?, return value from which column?,
[exact?]

what, where, which, [exact]

 

[jeffers185]

thanks george

-----Original Message-----
lol, i got that question once in a phone interview for a job.


what to look for?, where to look for it?, return value from which column?,
[exact?]

what, where, which, [exact]

--
George Nicholson

Remove 'Junk' from return address.

does anyone have any advice or a way to easily remember
how to compose this formula?

thanks

.

 

[George Nicholson]

Mea culpa!

of course, the 4th optional argument isn't [Exact?], it is the opposite:
[Approximate?], and the default is True.

--
George Nicholson

Remove 'Junk' from return address.

lol, i got that question once in a phone interview for a job.


what to look for?, where to look for it?, return value from which column?,
[exact?]

what, where, which, [exact]

--
George Nicholson

Remove 'Junk' from return address.

does anyone have any advice or a way to easily remember
how to compose this formula?

thanks