Without the column & row headers, it's impossible to tell if your formula is
correct. If you want to email me the spreadsheet, you can:


--
GD


"AcctCA755" wrote:

Here is the info again, I started the data at Column A.

Cust No Name Item

12582 smith Bean
5400 Jones Corn
9988 Brown apple
2255 Long Dress
22556 Shaw Shirt


Cust No Name Cust No Item

12582 smith 12582 =VLOOKUP(C7,Data!A7:C11,3,FALSE)
5400 Jones 5400
9988 Brown 9988
2255 Long 2255
22556 Shaw 22556

Thanks







--
AcctCA755


"AcctCA755" wrote:

What is from with this Vlookup? I formatted all cells as text, copy paste
special value all data, however, I don't receive the data in column 3.

The following is displayed: =VLOOKUP(D7,Data!B7:D11,3,FALSE)

The spreadsheets are below.

Cust No Name Item

12582 smith Bean
5400 Jones Corn
9988 Brown apple
2255 Long Dress
22556 Shaw Shirt

Cust No Name Cust No Item

12582 smith 12582 =VLOOKUP(D7,Data!B7:D11,3,FALSE)
5400 Jones 5400
9988 Brown 9988
2255 Long 2255
22556 Shaw 22556


Thanks





--
AcctCA755