Format of cells for VLOOKUP

[Cobaum]

OK, I am a little hungover this morning after a party last night in downtown
Denver after the DNC. Free drinks does not mean you have to drink
EVERYTHING. Anyway, now I have to get some work done and my brain is on 1/4
speed. I am trying to get a VLOOKUP formula to work. It is giving me a #N/A
for my formula. The problem is that the "lookup_value" column is formatted
as a value (has a ', ", or ^ in front of the number). If I copy the number
over from the "table_array" it drops the ', ", ^ and the formula works. I
would just copy the numbers over, but they are not in the same order between
spreadsheets (hence the vlookup formula), and there are over a thousand rows.
How do I reformat the cells where the VLOOKUP formula can use the number?

 

[Glenn]

OK, I am a little hungover this morning after a party last night in downtown
Denver after the DNC. Free drinks does not mean you have to drink
EVERYTHING. Anyway, now I have to get some work done and my brain is on 1/4
speed. I am trying to get a VLOOKUP formula to work. It is giving me a #N/A
for my formula. The problem is that the "lookup_value" column is formatted
as a value (has a ', ", or ^ in front of the number). If I copy the number
over from the "table_array" it drops the ', ", ^ and the formula works. I
would just copy the numbers over, but they are not in the same order between
spreadsheets (hence the vlookup formula), and there are over a thousand rows.
How do I reformat the cells where the VLOOKUP formula can use the number?

Does this help?

http://support.microsoft.com/kb/291047

 

[Cobaum]

Method 4 worked. I guess being hungover didn't matter - I wouldn't have
figured that out stone-sober. Thanks for the help.