Thanks,

Your answer set off a light bulb on some other things that had been
bothering me. I thought changing cell formats changed the data format. I
made the changes properly and things look good now.

"Elkar" wrote:

I'm guessing that the data in your Prices range is stored as Text. The cells
may be formatted as a Number, but that doesn't necessarily mean that the data
is a Number. Changing a cell format from Text to Number doesn't affect
existing data.

Try this:

In your Prices worksheet, enter a 1 into any blank cell.
Copy that cell
Select your range of data to convert from text to numbers
From the Edit Menu, choose "Paste Special..."
Select the options for 'Values' and 'Multiply'
Click OK
Delete the 1 you entered originally

Now, any text values in that range should be converted to numbers.

HTH,
Elkar





"ATIHelp" wrote:

I've got a very simple Vlookup function that is giving me a problem. I am
trying to find a match to a number, but can only get the match to work if I
enter an apostrophe (') before the number (found in C22) and make it a text.
I've checked that both the source cell and the searched cells are formatted
to identical number format.

=VLOOKUP(C22,Prices,2,FALSE)

"Prices" is a sheet in a second externally linked workbook.

Thanks