exact & inexact lookup

B

bingy

Lookup seems do an inexact lookup,How should I do an exact one?
Thanks for your answer.
(e-mail address removed)
 
J

John Wilson

bingy,

Use the "False" argument at the end.

=VLOOKUP(what,where,index,False)

John
 
B

bingy

VLookup & HLookup seems to demand the key to be in the 1st row or column,
and I could not get by it.
How?
bingy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reverse Index Function 5
How should I do a multi-key search like lookup 4
Autonumber field in Excel that behaves the same as Access 0
reference data of other workbook 1
How should I use VB funcition in Excel2000 0
How to replace text with numbers? (formula) 4
lookup and return column number 2
make Excel see a (one digit) number as text 5

Top