About Us

Don Guillett

Glad it helped

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dot" wrote in message
...
Thanks much Don as that worked!
--
Dot

"Don Guillett" wrote:

try if source is not sorted
=VLOOKUP(D2,custkey!$A$2:$B$1267,2,false)
or the same thing
=VLOOKUP(D2,custkey!$A$2:$B$1267,2,0)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Dot" wrote in message
...
I tried using vlookup to lookup information in 1 column then go to
another
worksheet and bring in the information for another column. Below is
the
formula I'm using but I either get #N/A or the wrong information. What
I
have is a list of outstanding payments I'm trying to match the customer
number from one sheet and on the custkey sheet I have the customers
account
number in column A and the person assigned to clear the payment in
column
2.
What am I doing wrong? Should I be using a different function key?

=VLOOKUP(D2,custkey!$A$2:$B$1267,2)

Dot

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
counting data in one column and match with data in another column	jenny	Excel Discussion (Misc queries)	1	October 26th 06 09:16 PM
Display missing Part Number if Column A does not match column B	Erik T	Excel Worksheet Functions	2	April 17th 06 11:23 PM
Sum of column C where results in column A match	DaiABolical	Excel Worksheet Functions	2	March 23rd 06 12:02 PM
Any way for 2 column vlookups. i.e match last name then match firs	CraigS	Excel Worksheet Functions	5	March 7th 06 12:30 AM
Need rows in Column A removed if they fully or partially match with any Column B row	[email protected]	Excel Discussion (Misc queries)	1	August 21st 05 11:41 PM