vlookup for client list
Just relook at VLOOKUP function help..
=VLOOKUP(lookupvalue,A:K,3,0)
should return the value from column C (which is the 3rd column of array A:K)
=VLOOKUP(lookupvalue,B:K,2,0)
should return the value from column C (which is the 2nd column of array B:E)
If this post helps click Yes
---------------
Jacob Skaria
"xololady" wrote:
I am working on a billing spreadsheet. Each client has a client ID plus
other details over 11 columns. I created client list with their specific
info. When I try to use a VLOOKUP formula on new worksheet, I can only get
client ID and name (first 2 columns) without the other columns. I want to be
able to type client id number and have the rest of the info automatically
fill in the row. Please tell me what I am missing.
Thank you, Karen
|