Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup on a cell with a formula
Hi,
I have added the values(text) of 2 columns together by either eg. =a1&""&a2 or =concatenate(a1,a2). I want to use the result of this as the lookup_value in a vlookup formula but get a #N/A error. Is it possible to use vlookup in such an instance? If so what can I do to make the formula work? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup on a cell with a formula
Minos,
Try using --(A1&A2) as the lookup value -- HTH RP (remove nothere from the email address if mailing direct) "Minos" wrote in message ... Hi, I have added the values(text) of 2 columns together by either eg. =a1&""&a2 or =concatenate(a1,a2). I want to use the result of this as the lookup_value in a vlookup formula but get a #N/A error. Is it possible to use vlookup in such an instance? If so what can I do to make the formula work? Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup on a cell with a formula
Minos Wrote: Hi, I have added the values(text) of 2 columns together by either eg. =a1&""&a2 or =concatenate(a1,a2). I want to use the result of this as the lookup_value in a vlookup formula but get a #N/A error. Is it possible to use vlookup in such an instance? If so what can I do to make the formula work? Thanks Minos, the concatenated values appear in *single* first column of your table? Or are they broken in two columns? If this is the case, then you need to use the combination INDEX(..., MATCH(...)) as an array formula (to be entered with Shift+Ctrl+Enter) =INDEX(K1:K10, MATCH(a1&b1, I1:I10&J1:J10,0)) In this example I am assuming your table lies in cells I1:K10, with columns I:J containing the values that form the key and K:K containing the values you want retrieved. HTH Kostis Vezerides -- vezerid ------------------------------------------------------------------------ vezerid's Profile: http://www.excelforum.com/member.php...o&userid=28481 View this thread: http://www.excelforum.com/showthread...hreadid=486803 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup on a cell with a formula
"Minos" wrote in message
... Hi, I have added the values(text) of 2 columns together by either eg. =a1&""&a2 or =concatenate(a1,a2). I want to use the result of this as the lookup_value in a vlookup formula but get a #N/A error. Is it possible to use vlookup in such an instance? If so what can I do to make the formula work? Thanks Don't add/concatenate anything. Simply use A1&A2 as the lookup value. Bruno |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need help creating formula based on cell value | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
looking for a formula | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |