Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm having trouble getting the VLOOKUP function to work.
=VLOOKUP(LEFT(C2,2),'Expense Categories'!B2:C11,2) Basically, I have a four digit string in column C. I want to match the first two digits against the two digit numbers I have in Table B2:C11 on another sheet, then have it return the text string in the second column of that table. Right now, I keep getting "#N/A" no matter what I do. I've tried changing the cell formats from text to number to general and still N/A. What am I doing wrong here? Thanks! mllestecchino |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
vlookup question | Excel Worksheet Functions | |||
VLOOKUP() Question... i hope | Excel Discussion (Misc queries) | |||
Vlookup question please | Excel Worksheet Functions | |||
vlookup question please | Excel Worksheet Functions | |||
Vlookup against multiple columns/worksheets question | Excel Discussion (Misc queries) |