Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tidy lookup
I want to pick 2 values at a time from a two tables like this (total 4
figures), situated on spearate sheets: Sheet1 Sheet2 So: Formula = 2+7+4+6 WEXZ WEXZ T T E E F 27 F 46 Q Q Number of columns is subject to change. Number of rows is constant. What is the least messy way of doing this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tidy lookup
I'm not sure what WEXZ represents. Do you have the text T E F and Q in
one column (and if so, which?) and is the value 27 in another column (which?) or in two separate columns in sheet1? Is the layout in Sheet2 the same? Will your formula be on Sheet2 or in yet another sheet? How many rows of data do you have, and where does the data start? Essentially, I think you can use a MATCH function to return the values, but I can't suggest a particular formula until you give the details asked for (well, I could, but I would have to make a lot of assumptions and you would have to amend the formula if those assumptions were not valid - increasing the chances of errors being made). Hope this helps. Pete On Jun 17, 10:29*pm, PBcorn wrote: I want to pick 2 values at a time from a two tables like this (total 4 figures), situated on spearate sheets: Sheet1 * * * * * * * * * * * * * Sheet2 * * * * * * * * So: Formula = 2+7+4+6 * * * WEXZ * * * * * * * * * WEXZ T * * * * * * * * * * * * * * *T E * * * * * * * * * * * * * * E F * * * 27 * * * * * * * * * F * *46 Q * * * * * * * * * * * * * * Q Number of columns is subject to change. Number of rows is constant. What is the least messy way of doing this? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Tidy lookup
Hi.
Sorry for the sloppy illustration. The column labels are represented by WEXZ (they are text - no order), the row labels are represented by TEFQ (text - no order). The two tables are identical. The numbers on the illustration are separate, eg, F:E = 2, F:X = 7. This shows how i would like to pick values out of the tables. The formula will be in a cell on another sheet. Thanks for your help "Pete_UK" wrote: I'm not sure what WEXZ represents. Do you have the text T E F and Q in one column (and if so, which?) and is the value 27 in another column (which?) or in two separate columns in sheet1? Is the layout in Sheet2 the same? Will your formula be on Sheet2 or in yet another sheet? How many rows of data do you have, and where does the data start? Essentially, I think you can use a MATCH function to return the values, but I can't suggest a particular formula until you give the details asked for (well, I could, but I would have to make a lot of assumptions and you would have to amend the formula if those assumptions were not valid - increasing the chances of errors being made). Hope this helps. Pete On Jun 17, 10:29 pm, PBcorn wrote: I want to pick 2 values at a time from a two tables like this (total 4 figures), situated on spearate sheets: Sheet1 Sheet2 So: Formula = 2+7+4+6 WEXZ WEXZ T T E E F 27 F 46 Q Q Number of columns is subject to change. Number of rows is constant. What is the least messy way of doing this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
Tidy Up | Excel Discussion (Misc queries) |