| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=vlookup(A1:A835,"bbb",AI7:AL165,C7:C165) giving #value! ????????
Hi I have a problem using vlookup between 2 large spreadsheets.
=vlookup(A1:A835,"bbb",AI7:AL165,C7:C165) where a1:a835 ia a list of codes on worksheet 1 "bbb" is the name of the second worksheet, AI7:AL165 is the range in the 2nd worksheet where the code will be found -I then want the text in column C of the row where the code is found All I am getting is #VALUE! Can you let me know where I am going wrong please as I cannot find an answer in the written help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| correct syntax for nesting "if", "and", and "vlookup"....if possib | Excel Worksheet Functions | |||
| Spell check giving "formula too long" - doesn't make corrections | Excel Discussion (Misc queries) | |||
| =IF(VLOOKUP(C11,Group,2,FALSE)=D11,"True","Not Valid") and =IF(D1 | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Vlookup and "-" negative numbers are giving me a #N/A | Excel Discussion (Misc queries) | |||
Threaded Mode
