How to use VLOOKUP to find data on another sheet
Hi
Can anyone advise me on how to use VLOOKUP when the data to be 'looked up' is on another worksheet in the same workbook. I also need to be able to look up a series of Lookup values in a given VLOOKUP formula, i.e. I need to write a single VLOOKUP formula which will search for DU52, DU92 & DU98 in column A and return the values found in column D on the rows corresponding to the values foundin column A. I hope this makes sense, as this is my first question on these forums. Thanks in advance. Cheers MikeyH |
How to use VLOOKUP to find data on another sheet
=VLOOKUP(DU52,Sheet2!A:D,4,False)
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "MIKEYH" wrote in message ... Hi Can anyone advise me on how to use VLOOKUP when the data to be 'looked up' is on another worksheet in the same workbook. I also need to be able to look up a series of Lookup values in a given VLOOKUP formula, i.e. I need to write a single VLOOKUP formula which will search for DU52, DU92 & DU98 in column A and return the values found in column D on the rows corresponding to the values foundin column A. I hope this makes sense, as this is my first question on these forums. Thanks in advance. Cheers MikeyH |
How to use VLOOKUP to find data on another sheet
Hi Bob
I must still be missing something as it's returning #N/A I've written the formula as follows: =VLOOKUP(DU52,VARIANT!A2:H44,4,FALSE) When I click in the formula bar, 'DU52' is in blue. Any ideas??? -- Cheers MikeyH "Bob Phillips" wrote: =VLOOKUP(DU52,Sheet2!A:D,4,False) -- --- HTH Bob (change the xxxx to gmail if mailing direct) "MIKEYH" wrote in message ... Hi Can anyone advise me on how to use VLOOKUP when the data to be 'looked up' is on another worksheet in the same workbook. I also need to be able to look up a series of Lookup values in a given VLOOKUP formula, i.e. I need to write a single VLOOKUP formula which will search for DU52, DU92 & DU98 in column A and return the values found in column D on the rows corresponding to the values foundin column A. I hope this makes sense, as this is my first question on these forums. Thanks in advance. Cheers MikeyH |
How to use VLOOKUP to find data on another sheet
XL thinks DU52 refers to the cell DU52.
Dave -- Brevity is the soul of wit. "MIKEYH" wrote: Hi Bob I must still be missing something as it's returning #N/A I've written the formula as follows: =VLOOKUP(DU52,VARIANT!A2:H44,4,FALSE) When I click in the formula bar, 'DU52' is in blue. Any ideas??? -- Cheers MikeyH "Bob Phillips" wrote: =VLOOKUP(DU52,Sheet2!A:D,4,False) -- --- HTH Bob (change the xxxx to gmail if mailing direct) "MIKEYH" wrote in message ... Hi Can anyone advise me on how to use VLOOKUP when the data to be 'looked up' is on another worksheet in the same workbook. I also need to be able to look up a series of Lookup values in a given VLOOKUP formula, i.e. I need to write a single VLOOKUP formula which will search for DU52, DU92 & DU98 in column A and return the values found in column D on the rows corresponding to the values foundin column A. I hope this makes sense, as this is my first question on these forums. Thanks in advance. Cheers MikeyH |
How to use VLOOKUP to find data on another sheet
Thanks Dave, that makes sense. How do I convince Excel that DU52 is not a
cell reference, but merely a data value? -- Cheers MikeyH "Dave F" wrote: XL thinks DU52 refers to the cell DU52. Dave -- Brevity is the soul of wit. "MIKEYH" wrote: Hi Bob I must still be missing something as it's returning #N/A I've written the formula as follows: =VLOOKUP(DU52,VARIANT!A2:H44,4,FALSE) When I click in the formula bar, 'DU52' is in blue. Any ideas??? -- Cheers MikeyH "Bob Phillips" wrote: =VLOOKUP(DU52,Sheet2!A:D,4,False) -- --- HTH Bob (change the xxxx to gmail if mailing direct) "MIKEYH" wrote in message ... Hi Can anyone advise me on how to use VLOOKUP when the data to be 'looked up' is on another worksheet in the same workbook. I also need to be able to look up a series of Lookup values in a given VLOOKUP formula, i.e. I need to write a single VLOOKUP formula which will search for DU52, DU92 & DU98 in column A and return the values found in column D on the rows corresponding to the values foundin column A. I hope this makes sense, as this is my first question on these forums. Thanks in advance. Cheers MikeyH |
How to use VLOOKUP to find data on another sheet
Put double quotes around it: "DU52" --that signifies that it is a text string.
Dave -- Brevity is the soul of wit. "MIKEYH" wrote: Thanks Dave, that makes sense. How do I convince Excel that DU52 is not a cell reference, but merely a data value? -- Cheers MikeyH "Dave F" wrote: XL thinks DU52 refers to the cell DU52. Dave -- Brevity is the soul of wit. "MIKEYH" wrote: Hi Bob I must still be missing something as it's returning #N/A I've written the formula as follows: =VLOOKUP(DU52,VARIANT!A2:H44,4,FALSE) When I click in the formula bar, 'DU52' is in blue. Any ideas??? -- Cheers MikeyH "Bob Phillips" wrote: =VLOOKUP(DU52,Sheet2!A:D,4,False) -- --- HTH Bob (change the xxxx to gmail if mailing direct) "MIKEYH" wrote in message ... Hi Can anyone advise me on how to use VLOOKUP when the data to be 'looked up' is on another worksheet in the same workbook. I also need to be able to look up a series of Lookup values in a given VLOOKUP formula, i.e. I need to write a single VLOOKUP formula which will search for DU52, DU92 & DU98 in column A and return the values found in column D on the rows corresponding to the values foundin column A. I hope this makes sense, as this is my first question on these forums. Thanks in advance. Cheers MikeyH |
How to use VLOOKUP to find data on another sheet
Thanks to Dave, that worked a treat.
I now have to write a formula to search for multiple lookup values and return the sum of the values found in column D .......... ?????? -- Cheers MikeyH "Dave F" wrote: Put double quotes around it: "DU52" --that signifies that it is a text string. Dave -- Brevity is the soul of wit. "MIKEYH" wrote: Thanks Dave, that makes sense. How do I convince Excel that DU52 is not a cell reference, but merely a data value? -- Cheers MikeyH "Dave F" wrote: XL thinks DU52 refers to the cell DU52. Dave -- Brevity is the soul of wit. "MIKEYH" wrote: Hi Bob I must still be missing something as it's returning #N/A I've written the formula as follows: =VLOOKUP(DU52,VARIANT!A2:H44,4,FALSE) When I click in the formula bar, 'DU52' is in blue. Any ideas??? -- Cheers MikeyH "Bob Phillips" wrote: =VLOOKUP(DU52,Sheet2!A:D,4,False) -- --- HTH Bob (change the xxxx to gmail if mailing direct) "MIKEYH" wrote in message ... Hi Can anyone advise me on how to use VLOOKUP when the data to be 'looked up' is on another worksheet in the same workbook. I also need to be able to look up a series of Lookup values in a given VLOOKUP formula, i.e. I need to write a single VLOOKUP formula which will search for DU52, DU92 & DU98 in column A and return the values found in column D on the rows corresponding to the values foundin column A. I hope this makes sense, as this is my first question on these forums. Thanks in advance. Cheers MikeyH |
All times are GMT +1. The time now is 05:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com