V lookup

  • Thread starter Thread starter jeff
  • Start date Start date
J

jeff

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

thanks
 
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]
 
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.


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

thanks
Click to expand...


.
Click to expand...
 
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.


George Nicholson said:
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.


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

thanks
Click to expand...
Click to expand...
 
Back
Top