| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
V Lookup
I have a workbook that I am trying to use a V- Lookup and all Excel returns
in the cell is the formula, no results. The formula is: =VLOOKUP(E2,'Provider-Dept'!$A2:$B53,2,FALSE). I have my array table sorted ascending - 1st column. Any ideas why Excel will only return the formula, not the result? The main table has the following columns: A1 B1 C1 D1 E1 F1 Pt Last Name Pt First Name CLINIC# Gender Provider Dept. My table array contains column headings and data: A1 B1 Provider Dept. ACM MONT AMZ NCE3 AVB NCW2 BCB S5AM BEE SEUR BG CHN1 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
V Lookup
Hi Sue,
Format the cell with the formula as General and re-enter the formula (F2, ENTER) -- Kind regards, Niek Otten Microsoft MVP - Excel "Sue" wrote in message ... |I have a workbook that I am trying to use a V- Lookup and all Excel returns | in the cell is the formula, no results. The formula is: | =VLOOKUP(E2,'Provider-Dept'!$A2:$B53,2,FALSE). I have my array table sorted | ascending - 1st column. Any ideas why Excel will only return the formula, not | the result? | | The main table has the following columns: | A1 B1 C1 D1 E1 | F1 | Pt Last Name Pt First Name CLINIC# Gender Provider Dept. | | My table array contains column headings and data: | A1 B1 | Provider Dept. | | ACM MONT | AMZ NCE3 | AVB NCW2 | BCB S5AM | BEE SEUR | BG CHN1 | | | | | |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
V Lookup
Sorry - I left off a column heading.
"Sue" wrote: I have a workbook that I am trying to use a V- Lookup and all Excel returns in the cell is the formula, no results. The formula is: =VLOOKUP(E2,'Provider-Dept'!$A2:$B53,2,FALSE). I have my array table sorted ascending - 1st column. Any ideas why Excel will only return the formula, not the result? The main table has the following columns: A1 B1 C1 D1 E1 E2 F1 Pt Last Name Pt First Name CLINIC# Gender Provider Dept. My table array contains column headings and data: A1 B1 Provider Dept. ACM MONT AMZ NCE3 AVB NCW2 BCB S5AM BEE SEUR BG CHN1 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
V Lookup
Hi Niek,
It works!!!! Would you please tell us, Sue and me, what the problem was? Thank you Chi "Niek Otten" wrote: Hi Sue, Format the cell with the formula as General and re-enter the formula (F2, ENTER) -- Kind regards, Niek Otten Microsoft MVP - Excel "Sue" wrote in message ... |I have a workbook that I am trying to use a V- Lookup and all Excel returns | in the cell is the formula, no results. The formula is: | =VLOOKUP(E2,'Provider-Dept'!$A2:$B53,2,FALSE). I have my array table sorted | ascending - 1st column. Any ideas why Excel will only return the formula, not | the result? | | The main table has the following columns: | A1 B1 C1 D1 E1 | F1 | Pt Last Name Pt First Name CLINIC# Gender Provider Dept. | | My table array contains column headings and data: | A1 B1 | Provider Dept. | | ACM MONT | AMZ NCE3 | AVB NCW2 | BCB S5AM | BEE SEUR | BG CHN1 | | | | | |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
V Lookup
The cell was formatted as text before you entered the formula
-- Kind regards, Niek Otten Microsoft MVP - Excel "Chi" wrote in message ... | Hi Niek, | | It works!!!! | | Would you please tell us, Sue and me, what the problem was? | | Thank you | Chi | | "Niek Otten" wrote: | | Hi Sue, | | Format the cell with the formula as General and re-enter the formula (F2, ENTER) | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | "Sue" wrote in message ... | |I have a workbook that I am trying to use a V- Lookup and all Excel returns | | in the cell is the formula, no results. The formula is: | | =VLOOKUP(E2,'Provider-Dept'!$A2:$B53,2,FALSE). I have my array table sorted | | ascending - 1st column. Any ideas why Excel will only return the formula, not | | the result? | | | | The main table has the following columns: | | A1 B1 C1 D1 E1 | | F1 | | Pt Last Name Pt First Name CLINIC# Gender Provider Dept. | | | | My table array contains column headings and data: | | A1 B1 | | Provider Dept. | | | | ACM MONT | | AMZ NCE3 | | AVB NCW2 | | BCB S5AM | | BEE SEUR | | BG CHN1 | | | | | | | | | | | | | |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
V Lookup
Hi Niek,
Thank you so much! Chi "Niek Otten" wrote: The cell was formatted as text before you entered the formula -- Kind regards, Niek Otten Microsoft MVP - Excel "Chi" wrote in message ... | Hi Niek, | | It works!!!! | | Would you please tell us, Sue and me, what the problem was? | | Thank you | Chi | | "Niek Otten" wrote: | | Hi Sue, | | Format the cell with the formula as General and re-enter the formula (F2, ENTER) | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | "Sue" wrote in message ... | |I have a workbook that I am trying to use a V- Lookup and all Excel returns | | in the cell is the formula, no results. The formula is: | | =VLOOKUP(E2,'Provider-Dept'!$A2:$B53,2,FALSE). I have my array table sorted | | ascending - 1st column. Any ideas why Excel will only return the formula, not | | the result? | | | | The main table has the following columns: | | A1 B1 C1 D1 E1 | | F1 | | Pt Last Name Pt First Name CLINIC# Gender Provider Dept. | | | | My table array contains column headings and data: | | A1 B1 | | Provider Dept. | | | | ACM MONT | | AMZ NCE3 | | AVB NCW2 | | BCB S5AM | | BEE SEUR | | BG CHN1 | | | | | | | | | | | | | |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variable Lookup/Double Lookup | Excel Worksheet Functions | |||
| Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
| Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
| Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
| How do I lookup and return different values when the lookup value. | Excel Discussion (Misc queries) | |||
Linear Mode
