Excel Vlookup function? 1

[SpankYou]

Hey,

Since my last post my job has changed again! basically I have a long list of data in one worksheet each with a unique numerical ID. In another worksheet if a number is typed into a cell, excel needs to check with the long list of data and try n match with typed in number with an ID number. If the ID number matches, it then takes the whole row of data from the long list and places it in the cells next to the number entered in by the user.

I know this is a lot to ask, so even if you could direct me to a book, or just give me a jist of what to do I'd me very appreciative. Unfortunately I'm new to excel.

Thanks

Sam

"You couldn't fool your mother on the foolingest day of your life if you had an electrified fooling machine." - Homer

 

[SQLBI]

Sam check out the Excel help files for VLOOKUP.

Your example is in fact very simple. all you need to do is have separate VLOOKUP formulas in the cells you want the values in

For example:

=VLOOKUP(A1,A1020,2) will return the the data stored in the 2nd column (Col B) of the range (A1020) where a match to A1 is found.

Just change the column ref for each of your cells in the results sheet to bring through the corresponding data.

"TIP":

VLOOKUP must be sorted alphabetically/Numerically to work, unless you add the ,False argument to your formula.

So

=VLOOKUP(A1,A1020,2)

Becomes

=VLOOKUP(A1,A1020,2,FALSE)





Leigh Moore
LJM Analysis Ltd

http://www.ljm-analysis.co.uk

 

[SpankYou]

Hey Leigh,

Funnily enough I came across the exact soloution as you posted. What I found was...

http://groups.google.com/groups?q=v...UTF-8&selm=7jo8np$fok$1@nnrp1.deja.com&rnum=2

thank you all the same, yours has clarified how it works n I am starting to feel a bit better with the whole excel business.

Thanks again

Sam

"You couldn't fool your mother on the foolingest day of your life if you had an electrified fooling machine." - Homer