Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLookup formula question
I want to populate cells on worksheet 2 from worksheet 1 with values that a
user selects from worksheet one. The user can select multiple values but I only need those values selected to appear and not repeat. For example there are two columns A1 through A8 and B1 through B8 on worksheet one. Column B contains different values in each cell. Users will choose the value(s) they want from Column B by typing an X in the corresponding column A. For example, the user wants the value from cell B4 so types an "x" in cell A4 which then populates cell C1 in worksheet two. Then they select Cell B5 and I have adjusted the range in C2 to omit values from A1:B1 so cell C2 is populated with date from B5. I am using the formula below in cells C1-C8 . VLOOKUP("x",sheet1!A1:B8,2,FALSE) This works but if the user only selects one or two values, lets say B4, it populates all cells C1 through C8 with that value. Is there a way to populate cell C1 in this instance and leave all other cells blank? Would some sort of Macro work better for this or can it be one at all? -- Tim at Alliant |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup question | Excel Discussion (Misc queries) | |||
VLOOKUP formula question | Excel Worksheet Functions | |||
vlookup question | Excel Worksheet Functions | |||
A question about VLOOKUP / any other helpful formula | Excel Worksheet Functions | |||
vlookup formula question | Excel Discussion (Misc queries) |