| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLookup help
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Threaded Mode
