Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VLOOKUP for a cell with both letters and numbers
Hello
I am trying to use VLOOKUP to find an exact match, the problem is that the cell contains data that is a series of letters and numbers. I have used vlookup to find and then return data successfully if the search cells are all letters OR all numbers, but can't get it to work when both are present. I have also tried formatting the cells to read as 'text', or 'general', neither of which made a difference. PLEASE HELP! Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
no row numbers or column letters DISPLAYED | Excel Discussion (Misc queries) | |||
How can I write in a text in a cell using numbers and the letters. | Excel Discussion (Misc queries) | |||
Finding Numbers with Cells that also contain letters | Excel Discussion (Misc queries) | |||
How do I change column labels from numbers to letters in Excel? | Excel Discussion (Misc queries) | |||
Hor to write numbers in letters in spanish | Excel Worksheet Functions |