| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I use "VLOOKUP" with cells containing both Text & Numbers?
I am attempting to create a cross reference between 2 spreadsheets. I am
currently using the "VLOOKUP" function to obtain my results. The problem that I have run into is the values being compared & the desired output can contain both numbers and text (some only contain numbers). The formula I am using will work only on numbers. How can I get this to work for a combination of both text and numbers? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linked cells and text boxes | Excel Discussion (Misc queries) | |||
| stopping pasted text deliminate across multiple cells | Excel Discussion (Misc queries) | |||
| Counting Occurrence of Text within Text in Cells in Range. | Excel Worksheet Functions | |||
| Cells formated as numbers are calculating like text | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Threaded Mode
