| Home |
| Search |
| Today's Posts |
|
|
|
#1
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) | |||
Hybrid Mode
