concatenate
I want to conatenate 2 cells. In cell A1 I have a Vlookup and cell A2 I have
a number. In cell a3 when I put =concatenate(a1,a2) I'm getting a #ref!. I'm sure it's because of the lookup, but I really don't want to change my lookup to a value. Is there anyway to get around it? Thanks. |
concatenate
It's not simply because of the =vlookup() in A1. If that formula returns an
error (or A2 contains an error), then you'll see an error. But if A1 evaluates nicely (no error), it should work ok. terri wrote: I want to conatenate 2 cells. In cell A1 I have a Vlookup and cell A2 I have a number. In cell a3 when I put =concatenate(a1,a2) I'm getting a #ref!. I'm sure it's because of the lookup, but I really don't want to change my lookup to a value. Is there anyway to get around it? Thanks. -- Dave Peterson |
concatenate
It is (almost?) impossible to make CONCATENATE() to return #VALUE, unless one of the input cells is #VALUE.
What are your input values or formulas? -- Kind regards, Niek Otten Microsoft MVP - Excel "terri" wrote in message ... |I want to conatenate 2 cells. In cell A1 I have a Vlookup and cell A2 I have | a number. | | In cell a3 when I put =concatenate(a1,a2) I'm getting a #ref!. I'm sure | it's because of the lookup, but I really don't want to change my lookup to a | value. | | Is there anyway to get around it? | | Thanks. |
concatenate
Sorry, you stated #REF, not #VALUE.
Please give your exact formula, where it is and the formulas and values of the input cells. -- Kind regards, Niek Otten Microsoft MVP - Excel "Niek Otten" wrote in message ... | It is (almost?) impossible to make CONCATENATE() to return #VALUE, unless one of the input cells is #VALUE. | What are your input values or formulas? | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | | "terri" wrote in message ... ||I want to conatenate 2 cells. In cell A1 I have a Vlookup and cell A2 I have || a number. || || In cell a3 when I put =concatenate(a1,a2) I'm getting a #ref!. I'm sure || it's because of the lookup, but I really don't want to change my lookup to a || value. || || Is there anyway to get around it? || || Thanks. | | |
All times are GMT +1. The time now is 11:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com